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. Best, jwc
