Avatar of steven
steven
Flag for United States of America 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
Microsoft SQL Server

Avatar of undefined
Last Comment
steven

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
steven

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
steven

ASKER
This pulled correctly I sory
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck