I have a table with references to other data, and I select the records
matching a particular user. All are displayed OK.

Some of the records have further details in a second table, and in the past
I'm sure I just did an in line select and got null for those lines that did
not have matches, but with FB2 everything I do to select a single field from
the other table results in only those records being displayed.

My 'solution' to the problem is now a CASE statement so that the select is
only active when records of a particular type are found. This may be the right
solution later anyway as other tables will link to other data types, but for
the simple case shouldn't ONE of the 'join' formats allow me to display the
main list and include lines from the second inter table where appropriate?

--
Lester Caine - G8HFL
-----------------------------
Contact - http://home.lsces.co.uk/lsces/wiki/?page=contact
L.S.Caine Electronic Services - http://home.lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk//
Firebird - http://www.firebirdsql.org/index.php