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?
Thanks,
-Steve
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
