title: Difference between 2 SQL tables
body: <p>I have two tables: tableA and tableB. How can I get all the records that are in tableA but not in tableB? I am interested in the proper way to do this, not workarounds. I've tried using a left join and then adding <code>where ID is not null</code>. It works, but I am not sure whether that is the right way to do it.</p>