MySQL Forums
Forum List  »  Microsoft Access

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
3994
Ave
August 02, 2004 05:03AM
3350
August 02, 2004 08:42AM
2943
Ave
August 04, 2004 01:01AM
Comparing 2 Tables in Ms Access
8399
March 14, 2005 10:58PM
3104
July 19, 2005 07:14AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.