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
|
|||
|
|||
Appending 2 tables
I start with tables x and y. Link DIST and OBS1
I get query1 with a select query. I want to get Query WANTED. I've tried NOT linking. TABLE x DIST OBS1 X CountOfSEG 3 09 1 62 3 09 1 63 3 09 1 69 TABLE Y DIST OBS1 X CountOfSEG 3 09 2 7 3 09 2 81 Query1 DIST OBS1 X X.CountOfSEG Y.CountOfSEG 3 09 1 62 7 3 09 1 62 81 3 09 1 63 7 3 09 1 63 81 3 09 1 69 7 3 09 1 69 81 Query WANTED DIST OBS1 X X.CountOfSEG 3 09 1 62 3 09 1 62 3 09 1 63 3 09 2 7 3 09 2 81 |
#2
|
|||
|
|||
Appending 2 tables - a UNION Query.
I got it with a UNION Query.
-----Original Message----- I start with tables x and y. Link DIST and OBS1 I get query1 with a select query. I want to get Query WANTED. I've tried NOT linking. TABLE x DIST OBS1 X CountOfSEG 3 09 1 62 3 09 1 63 3 09 1 69 TABLE Y DIST OBS1 X CountOfSEG 3 09 2 7 3 09 2 81 Query1 DIST OBS1 X X.CountOfSEG Y.CountOfSEG 3 09 1 62 7 3 09 1 62 81 3 09 1 63 7 3 09 1 63 81 3 09 1 69 7 3 09 1 69 81 Query WANTED DIST OBS1 X X.CountOfSEG 3 09 1 62 3 09 1 62 3 09 1 63 3 09 2 7 3 09 2 81 . |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Use a make-table query to combine two existing tables | Matt | Running & Setting Up Queries | 1 | June 16th, 2004 01:53 AM |
searching for "join tables" and "join word tables" | Uncle Bill | Tables | 1 | June 11th, 2004 09:33 PM |
Limit to Number of Tables | T'Kai | Database Design | 1 | June 8th, 2004 03:44 PM |
How do I design a database based on the information that will be stored? - Copy of Tables and hirearchies.zip (0/1) | Jim | Database Design | 1 | June 1st, 2004 01:44 PM |
Separate database for tables? | Holly Clifton | Database Design | 3 | May 18th, 2004 06:20 PM |