> SELECT f.ID, d.NAME FROM FILE f, DRIVER d WHERE (d.ID = f.DRIVER); > > However, the only reason I have this query set up as this is to get the name > of the driver easily, if one is set. > > How can this be helped? Should I just get the driver ID as a field, and then > do a second query on that?
I think this might work: select f.ID, d.NAME from FILE f LEFT OUTER JOIN DRIVER d ON (d.ID=f.DRIVER); _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
