|Subject||SV: [MULIG SPAM] [firebird-support] Select...Join Query|
|Author||Svein Erling Tysvær|
>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.Hi Jack, if the answer is not simply adding the word 'left' or 'right', then I don't understand your question.
>In following sample query, TableTwo is related to TableOne via foreign key relationship):
>Select kOne, apples from TableOne join TableTwo on FKone = kOne.
Hence, if not
Select kOne, apples from TableOne left join TableTwo on FKone = kOne
Select kOne, apples from TableOne right join TableTwo on FKone = kOne
is the answer you're looking for, then please rephrase your queston.