Left join works fine, thanks. Best, jwc
On Jun 2, 2014, at 3:59 PM, Svein Erling Tysvær svein.erling.tysv...@kreftregisteret.no [firebird-support] <firebird-support@yahoogroups.com> wrote: > >If this is possible in a single query, could you please show me to return > >the 'select'-ed column value in the example below, whether or not the FK > >condition is satisfied. > > > >In following sample query, TableTwo is related to TableOne via foreign key > >relationship): > > > >Select kOne, apples from TableOne join TableTwo on FKone = kOne. > > Hi Jack, if the answer is not simply adding the word 'left' or 'right', then > I don't understand your question. > > Hence, if not > > Select kOne, apples from TableOne left join TableTwo on FKone = kOne > > or > > Select kOne, apples from TableOne right join TableTwo on FKone = kOne > > is the answer you're looking for, then please rephrase your queston. > > HTH, > Set > >