SELECT * FROM contact, orders WHERE contact.contact_id=orders.order_id
SELECT * FROM contact, orders WHERE orders.order_id=contact.contact_id
Think of it this way: The part that comes after the WHERE key word is simply a conditional statement, either it evaluates as true (include the row) or false (don't include the row). So the order doesn't matter.