steven
asked on
Left outer join
I am trying to pull all locations that are not in the itemloc table but it is not working..I must not know how to the left outer works?
select m.*
from location_mst m
left outer join Itemloc_mst i on i.loc = m.loc
where m.description <> 'pa1'
and i.loc is null
------and i.loc <> 'stock'
order by i.loc
select m.*
from location_mst m
left outer join Itemloc_mst i on i.loc = m.loc
where m.description <> 'pa1'
and i.loc is null
------and i.loc <> 'stock'
order by i.loc
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER