Combine Results from 2 Tables into 1

[aftabn10]

Hi, I have 3 tables, one that shows all queue names and 2 other tables with results from different sources.

What i would like to do is to create a query that will get all the queue names and the matching results from the 2 tables but show this under 1 column.

At present the link between the 3 tables is the queue name but when running a simple query i have the queue name, results (table2), results (table3), but the results need to be combined into 1 but not sure how to do this. If somebody could please help, would really appreciate it.

Thanks in advance.

 

[DCrake]

Why do you want different items of information all appearing under one heading?

 

[aftabn10]

DCrake, The reason for this is that i collate weekly stats for queues but the issue being is that this comes from 2 different sources hence i have a separate table for each but these figures are for the same week hence the reason for wanting them under 1 heading.

Thanks for your help.

 

[gemma-the-husky]

but if these are really the same sort of data, then you are better having them in a single table, with an indicator field to identify the source.

but what happens if you get a third source. doing it your way, you need a complicated rewrite - that becomes ever more complex with each change.

 

[aftabn10]

gemma-the-husky, combining the 2 results table would be fine, but theirs no link between the two so would it be a case of joining the 2 tables?