Ordering from three tables
Posted on 2004-09-11
I've got a mysql database with three different tables which contain user evaluation data for different tests.
The tables all contain a unique id, date field, customerid field, ordered field and payed field.
Now the list I need to create is based on the latest date first. BUT a customer can order 2 or 3 different tests on different dates, these customers still have to be bundled by the first order date occurance...
A test can be ordered from any of the three tables or a combination of these.
The list is based on all the customers which have ordered but not payed yet, all customer data will come from a fourth table based on customerid.
Can anybody help me?? It sounds simple, but I haven't been able to solve it yet....