JOIN
Posted: Tue Oct 02, 2007 1:45 am
I am newb to sql.
tables
contact
contact_id
contact_name
orders
order_id
contact_id
Which one is right for the table?
i think both are correct as i am comparing and not assigning.
tables
contact
contact_id
contact_name
orders
order_id
contact_id
Which one is right for the table?
Code: Select all
SELECT * FROM contact, orders WHERE contact.contact_id=orders.order_id
SELECT * FROM contact, orders WHERE orders.order_id=contact.contact_id