Comparing 2 Tables in Ms Access
Posted by:
Laxmi
Date: March 14, 2005 10:58PM
I'vetwo MS Access tables with same samedata strucre. I want to compare the data in two tables and write the dirrerence to a new table.
My table strucre is as follows:
Table mytable
Category char(50),
SbPartNo char(50),
PartDesc char(200),
tol char(50),
manPartNo char(200),
manufacturer char(100),
vendor char(100),
pkg char(100),
spq char(50),
moq char(50),
leadTime char(2),
unitprice char(10),
refDesi char(200),
qty char(5),
totalprice char(10),
ecn char(200)
fOR EX:
Let's consider two tables as table1 and table2. Table2 may have some rows which are new, some rows that are modified version of rows in table1. Some rows that are present in table1 may not present here. I need to pull all these rows to a new table.
I'm not much conversant with sql syntax. If someone could provide the actual syntax and how it workds, it will be a great help.
Thanks in advance.