MySQL Forums
Forum List  »  Newbie

Re: Basic SQL Query Quesion
Posted by: Phillip Ward
Date: April 02, 2024 04:32AM

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):

FROM Table1 t1 
INNER JOIN Table2 t2 
      ON <=>

This would return the case where both and are NULL.

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

Regards, Phill Ward.

Options: ReplyQuote

Written By
March 29, 2024 11:48PM
Re: Basic SQL Query Quesion
April 02, 2024 04:32AM

Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.