>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