Re: Basic SQL Query Quesion

[Phillip Ward]

As stated, correct on all counts.

Just for completeness, though, there is one, very minor, edge case you might have to consider (but hopefully not):

 
SELECT
  t1.name
, t2.name 
FROM Table1 t1 
INNER JOIN Table2 t2 
      ON t1.name <=> t2.name

This would return the case where both t1.name and t2.name are NULL.

However, you should avoid joining on potentially NULL values because Indexes and NULLs don't play well together.

Regards, Phill Ward.