How would you create the SQL Select if you wanted the resulting query to have records from TABLE1 for PKs:
230
500
511
512
722
UPDATE: I think I figured it but it requires to have the variable in the JOIN expression; which I am trying to avoid.
UPDATE 2: I found the solution and the variable in JOIN is no longer a problem.
Thank you.
>Any time
>
>>You are right. I completely missed that I need to include another criteria in the JOIN or in the WHERE. Thank you.
>>
>>>The result is impossible for the query and data you posted.
>>>Most likely there're multiple records with PK=230 in one of tables or both.
>>>
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham