Posted by PeterA on 10/02/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

[Back to original message]