It's awfully hard for anyone to help without seeing the SQL that you are trying to execute. Ideally, the full descriptions of the tables involved and a few rows of sample data would make it a lot easier for us to be able to visualize what you are doing but you sometimes get a useful answer from the SQL alone.
The other thing that is vital for a good answer to this kind of question is knowing which version of MySQL you are running; later versions have much greater SQL capabilities than earlier versions. Rhino ----- Original Message ----- From: "Andrew Kuebler" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, October 13, 2004 11:22 AM Subject: SELECT SUM + 2 JOINS > 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 > > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
