Code Forums - View Single Post

DJMaze · 05-31-2007, 12:38 AM

left join bannanas b on (b.field1=a.field1 and b.field3 > 0 and b.field4 = 2)

It's just like multiple conditions inside where. Instead, it will only join bannanas if "all" conditions are met.

05-31-2007, 12:38 AM	#2 (permalink)
DJMaze Senior Contributor Join Date: Mar 2005 Posts: 651	left join bannanas b on (b.field1=a.field1 and b.field3 > 0 and b.field4 = 2) It's just like multiple conditions inside where. Instead, it will only join bannanas if "all" conditions are met. __________________ UT: Ultra-kill... God like!