I have created 3 queries with different contents, now I need to connect all of these three queries in a 4th query. So I would like to use queries as business object in Q4; however, I am running into an issue. I am coming from SQL background and would like to have have three three queries turn into temporary table and feed the data into 4th table. I am not too certain how that is possible, but I did hear in conference that we can use queries as business object.

I would like to connect these three queries under description based on the display fields not based on the BO I am using in these queries. Is it possible to do this? I hope I am explaining this correctly, I am pretty new to IMis and IQA thus the difficulties.

Here is an example of what I am trying to do, I will use my T-SQL to explain this

INSERT INTO #t_1

select id, name, address

from table 1

INSERT INTO #t_2

select id, name, address

from table 2

INSERT INTO #t_3

select id, name, address

from table 3

select name, address

from #t_1 t1

left join #t_2 t2

on t1.id = t2.id

left join t_3 t3

on t1.id = t3.id

Is this possible to do this in IQA? Or should I create a view for this and convert into a business object?