Re: How do I make all columns line up in the same row?

[Peter Brawley]

Write a join. If the cusotmer primary key is custID and the orders PK is orderID, that would be ...

SELECT c.*. o.*, i.*
FROM customers c
INNER JOIN orders o USING (custID)
INNER JOIN items i USING (orderID);

PB