Answer 1

Here as follows an example from sql curse. When you see that then you will imagine a right tables construction and joining of them.

SELECT customers.ID, customers.Name, orders.Name, orders.Amount
FROM customers, orders
WHERE customers.ID=orders.Customer_ID
ORDER BY customers.ID;