> Select Master.Master_ID,
> Detail1.Master_ID,
> Detail2.Master_ID,
> from Master
> join Detail2 on (Master.Master_ID = Detail2.Master_ID),
> join Detail1 on (Master.Master_ID = Detail1.Master_ID)

Notes:
I remove dthe ',' from the end of line 3 and then get an exception on
line 6 (last line):

Invalid token.
Dynamic SQL Error.
SQL error code = -104.
Token unknown - line 6, char -1.
join.

if I don't remove the comma. Remove the comma and nothing is returned.
Remarks:

I do think I want an outer join for I want a nulll if the there is no
record. Only one may exist in either detail1 or detail2, I need to
know, if one exists, which one.

Ed Dressel