Hi!
I have 3 tables. I want to run a query that collect some data from
them, and join into one result table.
I show a little example, how to do this in another DB with script:
create temp table tmp_a as select id, name, sum(cost) cost from items
where... group by id, name with data;
create temp table tmp_b as select item_id, sum(price) price from bills
where... group by item_id with data;
create temp table tmp_c as select item_id, sum(price) price from
incoming_bills where... group by item_id with data;
select
tmp_a.id, tmp_a.name, tmp_a.cost,
tmp_b.price outgoing_price,
tmp_c.price incoming_price
from tmp_a
left join tmp_b on (tmp_a.id = tmp_b.item_id)
left join tmp_c on (tmp_a.id = tmp_c.item_id)
order by name
This is very simple example. How I can write this in "WITH QUERY" form?
Thanks for every help!
dd
