Please help with query

[Anon]

Im making a backoffice/invoice program to a web shop. I have to tables. One for the order from the customer, and one for the invoice. Im trying to compare these tables and output a result where the items in the order table does not match the items in the invoice table. I want to get the order id from the order table as an result.

Could any1 please help me with an sollution to this?? Im not an professional mysql/php developer.

Thanks

Tom

[Anon]

You should write a script that generates an invoice from the order table, not have a seperate invoice table.

What I would recommend is having a customer table, with their name/address,etc and then have an order table with customer id, payment method, delivery method, etc and finally an order items table which has the items that make up the order.

Then you can select the items by

SELECT * FROM orderitems WHERE OrderID=$orderid

or similiar, where $orderid would be the primary key in your orders table.

[Anon]

Basically, you need to left join orders and invoices. Left join means the result will include all records from the first table whether there's a corresponding record in the second table or not. Then just add a where clause to look for records with a null value in an invoice field (preferably one that's declared NOT NULL). That should give you only the unmatched records.

HTH,
Beth