Hi there.

Trying to load new table based on the following and I am getting a nested loop join...

Customer Table
Canceled Table
New Table

I am declaring cursor as SELECT * from Customer t1, Canceled t2
where Customer.id <> Canceled.id

This is giving me a nested loop. Obviously my SQL skills are terrible. I can't figure out how to write the SQL to only load into the new table where the ID in Customer does not equal the ID Cancelled.

Any help?
Thanks all.

Maybe something like this:

SELECT * from Customer t1 where not exists (select 1 from Canceled t2 where t1.id = t2.id);

This worked. I've got to get my SQL skills up to speed. Sheesh.

Thanks, Marcus.

What's wrong with a nested loop, and how is that related to SQL skills?

You could also use an outer join and select records that have no match.

The nested loop gave me a Cartesian product and I had to terminate the load. My SQL skills are terrible because I couldn't figure a way out of it.