[postgis-users] OT: Help with a join

Stephen Woodbridge woodbri at swoodbridge.com
Mon Jun 30 09:16:54 PDT 2008

Hi all,

I could use a little help with a join:

select a.tlid, b.fullname, b.paflag, a.mtfcc, c.fromhn, c.tohn, c.side, 
c.zip, c.plus4, a.statefp, a.countyfp
   from featnames b, addr c, addrfn d, edges a
  where a.tlid=b.tlid and b.tlid=c.tlid and b.linearid=d.linearid and 
c.arid=d.arid and a.roadflg='Y'
  order by a.tlid, b.fullname, c.side ;

I need to get back records for every record in edges even if there is no 
matching tlid in the addr table.

How do I do that?


More information about the postgis-users mailing list