Importing no duplicate records from a table in another

  • Thread starter Thread starter giannis
  • Start date Start date
G

giannis

I need an append query that imports all the
no duplicate records in a table from another one.

Suppose that Table1 is the target table with
the fields field1 and field2 and suppose that
Table2 is the sourse table with fields F1 and F2,
the query for all the records is :

INSERT INTO Table1 ( field1, field2 )
SELECT [Table2].[F1], [Table2].[F2]
FROM Table2

What is the query for all - no duplicate- records ?
(what must write in the WHERE ?)
 
You can use an Aggregate Query (Group By) to get only unique records. You
can also use the Distinct predicate to return unique fields, or the
Distinctrow predicate (Access/Jet only) to return unique rows of data.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

giannis said:
I need an append query that imports all the
no duplicate records in a table from another one.

Suppose that Table1 is the target table with
the fields field1 and field2 and suppose that
Table2 is the sourse table with fields F1 and F2,
the query for all the records is :

INSERT INTO Table1 ( field1, field2 )
SELECT [Table2].[F1], [Table2].[F2]
FROM Table2

What is the query for all - no duplicate- records ?
(what must write in the WHERE ?)
Click to expand...
 
Some example plese !!!!!

Arvin Meyer said:
You can use an Aggregate Query (Group By) to get only unique records. You
can also use the Distinct predicate to return unique fields, or the
Distinctrow predicate (Access/Jet only) to return unique rows of data.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

giannis said:
I need an append query that imports all the
no duplicate records in a table from another one.

Suppose that Table1 is the target table with
the fields field1 and field2 and suppose that
Table2 is the sourse table with fields F1 and F2,
the query for all the records is :

INSERT INTO Table1 ( field1, field2 )
SELECT [Table2].[F1], [Table2].[F2]
FROM Table2

What is the query for all - no duplicate- records ?
(what must write in the WHERE ?)
Click to expand...
Click to expand...
 
Back
Top