Afternoon all
I have recently uploaded an article/bog to my web site re different
SQL joins (or more specifically SQLite joins). While this article uses
The Forensic Browser for SQLite as the query engine, the concepts
discussed are relevant (and mainly discuss hash matching) for anyone
who has large tables of data that they want to filter/compare. The SQL
can of course be used in any SQL query engine.
http//
Cheers
Paul
Detailed, and informative. Thank you for taking the time to do it!
Great article Paul. I recently had to write a query simulating a 3 table FULL OUTER JOIN in SQLite. It got…lengthy… but luckily, in that case, the results were very compelling, so it was all worth it.
Thanks for sharing.
Thanks both
Doing lots of work with the Browser at the moment and a side effect of that is lots of work on SQL queries as I help customers (not that most need it as the visual query design makes most queries and joins easy).
I have another article up my sleeve that shows off some of the power of SQL (I think I mentioned it to you at the conference Alex). It's abit more complex so i am working through it trying to simplify as much as I can.