faqts : Computers : Databases : MySQL : Language and Syntax : Queries : Joins

+ Search
Add Entry AlertManage Folder Edit Entry Add page to http://del.icio.us/
Did You Find This Entry Useful?

6 of 9 people (67%) answered Yes
Recently 5 of 8 people (63%) answered Yes

Entry

I have Two tables Contacts and Address. What is the easiest way to reference an address to a contact?

Sep 13th, 2002 12:38
Euan MacInnes, Jason Bell,


select contacts.*, address.* 
from contacts,address
where contacts.address_id=address.address_id