>I keep thinking that I'm missing the obvious and I'm getting lost in multiple SQL statements. Here's what I'm trying to do:
>
>I have two tables with the same structure. I want to delete all the records in the first table that match a record in the second table. The whole record doesn't have to match; just the custno and city.
>
>I've been doing SELECTs into temp tables and setting relations and just generally getting myself confused. I have the feeling that there's a simple solution that I'm missing.
>
>Anyone know what it is?
>
>Thanks,
>
>Michelle
Michelle,
Did you try SQL DELETE like:
DELETE FROM customer WHERE customer_id = myothertable.customer_id
Nick
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro
"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison