Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Finding duplicate records from two separate records
Message
 
 
To
14/01/2002 17:12:45
General information
Forum:
Microsoft Office
Category:
Access
Miscellaneous
Thread ID:
00604607
Message ID:
00604628
Views:
20
Thank you. Just what I needed!
Max

> An INNER JOIN on all fields should give you what you want. In other words, a query that returns the matches from both tables where all fields are the same. Something like this should work:

> Select Table1.* From Table1 Inner Join Table2 On Table1.fld1=Table2.Fld1 And Table1.fld2=Table2.fld2 .. etc.
> HTH
Previous
Reply
Map
View

Click here to load this message in the networking platform