Code Forums - View Single Post

sde · 05-30-2007, 05:43 PM

Code:

select a.field1 b.field2 from apples a
  left join bannanas b on b.field1=a.field1 and b.field3 > 0 and b.field4 = 2
  where a.field2='foo'

can anyone explain what the code after the left join means? .. i understand b.field1=a.field1, .. but i came across some code today which has more conditions after the left join and before the where clause.

05-30-2007, 05:43 PM	#1 (permalink)
sde Moderator Join Date: May 2002 Location: us.ca Posts: 4,444	clauses in a join Code: select a.field1 b.field2 from apples a left join bannanas b on b.field1=a.field1 and b.field3 > 0 and b.field4 = 2 where a.field2='foo' can anyone explain what the code after the left join means? .. i understand b.field1=a.field1, .. but i came across some code today which has more conditions after the left join and before the where clause. __________________ Mike