title: How to return rows from left table not found in right table?
body: <p>I have two tables with similar column names and I need to return records from the left table which are not found in the right table? I have a primary key(column) which will help me to compare both tables. Which join is preferred?</p>