|
Posted by PeterA on 06/20/24 11:51
Thanks, Jason. I got it to work using basically this core of code. I
had simplified the question for the purpose of getting a straight
answer, but your code is the core of the soluton. Much appreciated!!
Jason wrote:
> Try one of these:
>
> SELECT * FROM tableA WHERE client_id NOT IN (SELECT client_id FROM
> tableB)
>
> SELECT a.*
> FROM tableA a
> LEFT JOIN tableB b ON a.client_id = b.client_id
> WHERE b.client_id IS NULL
>
> you should see better performance on the second one if you have a lot
> of rows in your tables.
>
> Jason
Navigation:
[Reply to this message]
|