--- In firebird-support@yahoogroups.com, Lester Caine <lester@...>
wrote:

>
> 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?


Hi, Lester

I am not quite sure if I get you right, but maybe this will help

select MainTable.MainField
, SecondTable.SecondField
from MainTable
left outer join SecondTable on SecondTable.MainTableID =
MainTable.MainTableID



Regards,
Zlatko