> 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?
Hi Alex,
For this you need an outer join (Made easy as of postgresql 7.1)
Alexander Deruwe Wrote:
> Hey all,
>
> I'm sorry if this question came up before, I couldn't find it in the
> archives..
>
> Suppose I have two tables:
>
> table File: contains alot of fields + 'driver' field, which refe
