SV: [MULIG SPAM] [firebird-support] Select...Join Query

[Svein Erling Tysvær svein.erling.tysv...@kreftregisteret.no [firebird-support]]

>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