[postgis-users] OT: Help with a join
woodbri at swoodbridge.com
Mon Jun 30 09:16:54 PDT 2008
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