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.
I have tried using WHERE o.Prodid NOT LIKE i.Prodid, but what happens is that it loops out the invoice id as many times for that order number that the items actually matches.
Could any1 please help me with an sollution to this?? Im not an professional mysql/php developer.
Thanks
Tom
