Skip to Content
0
Former Member
Dec 13, 2013 at 03:31 PM

How can I append two tables in a WebI query?

695 Views

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 table:

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.

Many thanks!

Leslie

.