
September 30th, 2004, 03:22 PM
|
|
Registered User
|
|
Join Date: Sep 2004
Posts: 1
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
SQL Query Info
Assuming that the contact information is an instance within this database. What is the proper way to conduct a SQL query to display Name, Address, and Contact Information given the following information.
There is a simple 3 table contact management database, the 3 tables are “Name”, “Address”, and “Contact”.
The Name table has the following fields:
• NameKey, FirstName, LastName, MiddleName
The Address table has the following fields:
• AddressKey, Street, City, State, Zip, Name
The Contact table has the following fields:
• ContactKey, HomePhone, WorkPhone, Mobile, Email, Name
Thank you..
|