Left Outer Joins with Restrictions on Outer Table

[Luvsql]

Table 1

Order No Item Qty
12345 X 25
12345 Y 20
98765 X 5


Table 2

Order No Item Qty
76522 X 2
76522 Y 3
56789 X 4

I need to join Table 1 to Table 2 on Item and only for OrderNo=12345 from Table 1 and 76522 on Table 2. If I do a left outer join from Table 1 to Table 2, if I enter a restriction on Table 2, it changes it to an equal join.

 

[IanWaterman]

in your select statement you will have
tabel2.field = x

change to
(isnull(tabel2.field) or tabel2.field = x)

Ian