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