R
rotor
Hello, I'm using Access 2002, ADO, DAO, and SQL. PLEASE help me
I have several Access DBs that are used only as a container for the purpose of holding query details as audit support. So the tables contained in these DBs are not linked and do not have any cross relationships
In one particular DB I have two tables, each containing a separate import from Oracle. I need a SQL string that will somehow identify those records in Table1 that are also contained in Table2. Each table has 26 columns, but only three columns (call them Field1, Field2, Field3) are needed to determine a match. Table1 has about 12,000 records, Table2 has about 113,000 records
Can someone please help me out here with a SQL string that will update a column in Table1 to indicate those records that are in both tables? Or, the query could alternatively write the duplicates into a new table. I'm relatively new at working with Access, please provide example code
Any assistance on this would be greatly appreciated. Thanks much in advance
I have several Access DBs that are used only as a container for the purpose of holding query details as audit support. So the tables contained in these DBs are not linked and do not have any cross relationships
In one particular DB I have two tables, each containing a separate import from Oracle. I need a SQL string that will somehow identify those records in Table1 that are also contained in Table2. Each table has 26 columns, but only three columns (call them Field1, Field2, Field3) are needed to determine a match. Table1 has about 12,000 records, Table2 has about 113,000 records
Can someone please help me out here with a SQL string that will update a column in Table1 to indicate those records that are in both tables? Or, the query could alternatively write the duplicates into a new table. I'm relatively new at working with Access, please provide example code
Any assistance on this would be greatly appreciated. Thanks much in advance