List:General Discussion« Previous MessageNext Message »
From:Jerry Schwartz Date:February 3 2009 8:54pm
Subject:RE: WHERE vs. ON
View as plain text  


From: Martin Gainty [mailto:mgainty@stripped] 
Sent: Tuesday, February 03, 2009 1:03 PM
To: Jerry Schwartz; mysql@stripped
Subject: RE: WHERE vs. ON


ON condition uses the same columnname from both source and target tables

whereas any column expressions can go in the WHERE clause...

[JS] That isn't necessarily true.


ON a.x = b.y

Is valid.

WHERE vs. ONJerry Schwartz3 Feb
  • RE: WHERE vs. ONMartin Gainty3 Feb
    • RE: WHERE vs. ONJerry Schwartz3 Feb
      • Re: WHERE vs. ONRob Wultsch3 Feb
  • Re: WHERE vs. ONPerrin Harkins3 Feb
  • Re: WHERE vs. ONBaron Schwartz4 Feb
    • RE: WHERE vs. ONJerry Schwartz4 Feb
    • Re: WHERE vs. ONJohn Daisley4 Feb
      • RE: WHERE vs. ONJerry Schwartz4 Feb
    • Re: WHERE vs. ONClaudio Nanni4 Feb
  • Re: WHERE vs. ONMartijn Tonies4 Feb