Joining 2 Queries

[jonnymenthol]

Hi,

I wonder if anyone can help me please - I'm not very good with Queries.

I have a DB which logs the number of a particular type of calls taken in a day.

Into this DB, there is a table which holds data that is imported which shows the number of another particular type of calls taken in a day.

I would like both of these one one query or report.

For example, it would show :

Person's Name - No of Call Type 1 - No of Call Type 2
John Smith - 105 - 220

What would be the best way of achieving this ?

Thanks in advance.

J

 

[llkhoutx]

Use a UNION query

Select tbA.A, tbA.B from tbA UNION Select tbA.A, tbA.B from tbB;

Note that the same datatype fields have to be selected from each table.