Hi, I'm quite new to mysql and I need to join two tables:
Items IDItems Name 1 Orange 2 Apple 3 Bread 4 Milk ... Invoice IDInvoice IDItems Qty 1001 1 10 1001 3 2 1002 2 5 ... I need to get all items and for items included in invoice (IDInvoice) the qty Results for IDInvoice = 1001 IDItem Name Qty 1 Orange 10 2 Apple 0 3 Bread 2 4 Milk 0 Did somebody have an idea? I tried with LEFT JOIN / RIGHT JOIN / INNER JOIN... with no success Thanks for any help Cedric -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
