I have 2 mysql queries. IE.
SELECT * FROM checkregister
AND
SELECT * FROM deposits
These tables have no fields that can be directly related but they both have a date field in which none of the dates exactly match. I need to somehow combine these queries so that I can list the results in order by date. For example:
checkno1 July 1, 2002
deposit1 July 2, 2002
checkno2 July 3, 2002
I have tried selecting both tables from 1 query but it returns duplicates of everything. It doesn't seem very hard but I can't find an answer anyplace and I've been "tinkering" for hours. I'm starting to wonder if it can be done since I haven't been able to find anything on it. Any help would be greatly appreciated. Thanks!
Paul