Posted by cobolman on 06/28/07 11:08

Actually I want to delete all rows which is duplicate on NAME and
TYPE.

Name Type Tag
---------------------------------
TEST1 12 A
TEST1 12 B
TEST2 12 A
TEST4 14 B

If you take this example, I'd like to delete TEST1 and only have TEST2
and TEST4 left in my table.

This is a temporary table used to compare tables in different
databases.
I move all the tables from both databases into this temp table, and to
find the tables that are found only in on of the databases, I want to
perform the deletion as mentioned above.

The result should give me the tables (occurences) that is missing in
one of the databases. The TAG tells me which.

• Next in forum: Re: DELETE where syntax ... need help :)
• Prev in forum: Re: Performance between Standard Join and Inner Join
• Thread view: Re: DELETE where syntax ... need help :)

[Reply to this message]