Re: syntax of select for a left join

I think this is an OUTER JOIN, and a select statement would look something like: select a.x, b.z from a, outer b where a.y = b.y order by a.x I use these some, and they can get a little confusing, but the basic approach is as shown above. Jun Yan wrote: > > Hi, can someone tell me the correct syntax for a left join? > > What I have is: > Table 1: > people's name|...|office building code|... > > Table 2: > building code | full name of buildings > > What I want is a list of all people with full building name, if someone > does not have an office, I still want it, just leave the building's name > blank. > > Thanks in advance. -- ------------------------------------------------------------------ Bradford S. J. Young | E-mail: byoung@cornercap.com Cornercap Investment Counsel | Tel: (404) 870-0700 Atlanta, GA | Fax: (404) 870-0770