Subject Select...Join Query
Author Jack Cane
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.