Re: DELETE where syntax ... need help :)

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.



.

Relevant Pages

  • Re: Duplicating Records
    ... it is - which is why most databases are built using one-to-many ... you'll need to duplicate all the fields ... increment, otherwise you'll need code to create a new unique ID. ...
    (microsoft.public.access.gettingstarted)
  • Re: how do i eliminate duplicate records?
    ... Deleting may work better if you sort by that key column first. ... the duplicate, what I want to do it if a duplicate is found, I want to ... different databases. ...
    (microsoft.public.excel)
  • Re: Query to Difference Two Databases
    ... Create a query with both tables in the input section and link the records via ... records of two databases. ... One database is a duplicate of the other, ... another location that is physically separate. ...
    (microsoft.public.access.queries)
  • Re: how do i eliminate duplicate records?
    ... if it's in both databases, 1 if it's in only the original database. ... the duplicate, what I want to do it if a duplicate is found, I want to ... Dave Peterson ...
    (microsoft.public.excel)
  • Re: how do i eliminate duplicate records?
    ... Be careful if any of your values appear an odd number of times. ... RobR wrote: ... the duplicate, what I want to do it if a duplicate is found, I want to ... different databases. ...
    (microsoft.public.excel)