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 refers to another table. I did not 'reference' it when creating the database because null-values have to be possible for this field. Now, if in this File-table the field 'driver' is not filled in, the row will not be included in a query such as this one: 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? Thanks, Alexander Deruwe ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])