My Assistant
Site Message
(Message will auto close in 2 seconds)
  |
 Comparing two tables in a database
|
|
 Apr 19 2005, 10:46 PM
Post
#1
|
|
|
UtterAccess Enthusiast Posts: 59  |
Could someone tell me if there is a way I can compare tables, retrieving only the information if it exist in both tables.
example: table One Table two Helen Helen Mike Sue Joe Joe The table results would contain Helen and Joe I need to compare this information as soon as possible, any help is appreciated. |
 |
 
|
|
Apr 19 2005, 11:02 PM
Post
#2
|
|
|
Utterly Abby-Normal Posts: 9,754 From: Seattle, WA [USA] |
What is the matching field you are searching? Is it unique to the record?
Something like this should work: CODE Select MyTable1.* , MyTable2.* From MyTable1 T1 Inner Join MyTable2 T2 On T1.MatchingField = T2.MatchingField; HTH |
|
|
|
|
Apr 20 2005, 07:01 PM
Post
#3
|
|
|
UtterAccess Enthusiast Posts: 59 |
Could you please provide detailed information on where I should enter this information. Is it in a query or what or am I during a macro? I am not that computer savvy. thanks in advance
|
|
|
|
|
Apr 20 2005, 07:42 PM
Post
#4
|
|
|
UtterAccess VIP / UA Clown Posts: 25,041 From: LI, NY |
Just create a query with the 2 tables. Join them on the matching field.
|
|
|
|
|
Apr 20 2005, 09:02 PM
Post
#5
|
|
|
Utterly Abby-Normal Posts: 9,754 From: Seattle, WA [USA] |
The script is for a query.
You'll be better off following Scott's advice by using the QBE to create the query. HTH |
|
|
|
 |
|
Jump To Forum:
|
Go to Top · Lo-Fi Version | Time is now: 20th May 2013 - 11:28 PM |