I have a MySQL table with Order#'s (Primary Key).
I want to total the number of items per order which I do through an inner join to the order contents, but then I want to also get a total on the amounts a customer has been billed to make sure there isn't a customer that has been shipped something they haven't paid for. Everything is ok until I do the left join on the payments which there could be more than one of for each order. Is it possible to do what I am asking in one query? I hope I have made sense. Best Regards, Andrew