From: Martin Gainty [mailto:[email protected]] 
Sent: Tuesday, February 03, 2009 1:03 PM
To: Jerry Schwartz; [email protected]
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.

Reply via email to