Article:  |
More on JOINS | |
| Subject: | Relationship: one to one | |
| Date: | 2001-06-08 06:14:43 | |
| From: | wallinbl | |
|
Response to: Relationship: one to one
|
||
|
If you have a Customer Table (with columns CustKey, CustFirstName, CustLastName) and an Address Table (with columns AddrKey, CustKey, AddrLine1, AddrLine2), to get all fields from both tables, you would write a query like this:
|
||
Women in Technology
Hear us Roar
