Join sum sql statement

[seralasu]

Hi,
I have two tables.One of them is used only in run time( like temporary table). While I 'm passing from page to another, I'm using two table.
Temporary table have fields:
stok_no miktar dusulen_id
Real Table have fields;
id stok_no kalan

we assume that user inserted some data
Real table

id    stok_no  kalan
393   1375     10
394   1375     8 
 

Temporary table

stok_no  miktar   dusulen_id
1375     3        393
1375     4        393
 

Finally I want to show this

id  stok_no  kalan miktar  toplam fark
393 1375     10    6       4
394 1375     8     0       8
 

I have sql statement but it doesn't work as I want

SELECT (D.kalan-G.miktari) kalan
FROM ayniyat_fis_detay D,
(SELECT dusulen_id, SUM(miktari) as miktari
FROM ayniyat_fis_detay_gecici
GROUP BY dusulen_id) G
where D.id= G.dusulen_id

It works only id=393 because temporary table has it.

[pradeep kaltari]

Hi,
I guess using LEFT OUTER JOIN will solve your problem.

Regards,
Pradeep.

[pbmods]

Are you using the temporary table to store calculated values, or is your temporary table more like a 'view' of other existing tables?

If it's the latter (and in a couple of cases, even if it's the former), you might want to consider using a view instead.