|
|
Posted by Jim Moseby on 07/08/05 20:10
Jim F wrote:
> Hi,
>
> I have two tables (A and B) with id fields in them, I would like a list of
> ids that are in A but not in B.
>
> How would I do this in SQL?
>
> Thank you,
>
> Jim
>
>
I have no way to test this where I am right now, but it will be
something like this:
select ID from table_a left join table_B on table_a.ID=table_b.ID where
table_b.ID is null;
JM
Navigation:
[Reply to this message]
|