> Sir, your query doesn't work on my machine. I either have to GROUP BY
> orderID, or drop orderID and Name from the SELECT clause. I'm not
> sure what you're trying to do, so I don't know which to suggest.
Oh, sorry, I didn't check out what did I wrote... ;) Anyway, I got this work after
GROU
>Hi there,
>
>I have five tables in the database: customers, orders,
>ordercontents, products and payments. The problem is that I should
>get a list which shows some kind of a ledger list (shows who has
>paid and so on).
>
>My first try looks like this:
>SELECT orders.OrderID, customers.Name, S
