I have one table that has parent tickets and one table that has work orders, which are sometimes, but not always, children of tickets.
I need to combine all of these into one query "table" so that I can sort/group/tally the aggregate of all work orders and tickets for a month.
The names of the fields differ, ie:
Incident #, date open, date close, group, subject
Work order table:
HD# [this is incident #], date open, date close, group, subject
I also need to know how to join on the incident #.
I'm thinking this will be easiest in the SQL.