RE: WHERE vs. ON

[Jerry Schwartz]

 

 

From: Martin Gainty [mailto:mgai...@hotmail.com] 
Sent: Tuesday, February 03, 2009 1:03 PM
To: Jerry Schwartz; mysql@lists.mysql.com
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.