|
|
|
|
|
| | |
| |
Active Server Pages ASP programs help tutorial tutorials routine routines jobs listserve mailinglist bulletin board bulletin boards programming snippet snippets CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
Re: Fundamental Query Info Needed |
|
From: |
elewis |
|
Date: |
4/18/2000 12:03:40 PM |
|
IP: |
204.106.63.6 |
I think what you are looking for is referred to as an outer join. This basically says to the query engine - give me all the records from this table (people) and by the way if there are related records in another table give me them too.
To accomplish this in Access:
1) start a new query in design view,
2) put your related tables in the query grid,
3) drag the related fields from your main table to the others (those that may or may not have records in them) to create the joins,
4) double-click the join line and change the join type to number 2.
Important note: After you close the Join Proprties window the join line should look like an arrow pointing away from your main table toward the other tables.
5) add the fields you want to see to the output section of the query window.
Click the Run button and you should see all the records from your main table and any records that may exist in the other tables. You will also have nulls in the columns from the tables that dont have any related data in them.
HTH |
Previous Message
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
