I am sure once I see the answer it will be an ah-ha moment..
I have one table with Preventive Maintenance records for a piece of equipment. And I have another table with Work Order records..
I want to bring them together in date order... so the query would be
PM Date 1
PM Date 2
WO Date 3
WO Date 4
PM Date 5
PM Date 6
etc. So I have a chronological order of events by date to see if a machine is ok or having issues do to alot of work orders between pm's.
I appreciate any help.