|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
February 23rd, 2007, 05:26 PM
posted to microsoft.public.access.queries
|
|||
|
|||
Merging data - no duplicates
Hi,
I have two tables with Owner information in each. I want to create a single data set, without duplicates. Can anyone suggest an approach? -- Carlee 
|
|
#2
February 23rd, 2007, 05:30 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Merging data - no duplicates
Hi,
TABLE tableName1 UNION TABLE tableName2 If you want all the records, use UNION ALL instead of UNION Hoping it may help, Vanderghast, Access MVP "Carlee" wrote in message ... Hi, I have two tables with Owner information in each. I want to create a single data set, without duplicates. Can anyone suggest an approach? -- Carlee
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
