>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