Case studies: innovative use of the union query (page 2 of 4)
Ok, we've entered all records in the database. The table below lists the most essential details of each and every move. Because it seems pointless to cough up all the files on one page, we show 15 records at the time.
However, even if we sort the records on origin date, or on delivery date it does not
help us with the planning, because we want to have an overview per day what's happening, packing or delivery, in the UK or abroad. It's still a bunch of files.
We would be much better off with a list of jobs, every job representing either a delivery, or a packout. next page >>
