>>>Anybody can see if it could be done with one SQL select?
>>>
>>>TIA.
>>
>>I dont know for only 1 select.
>>But in 2 step:
>>
>>

>>* put all needed info in 1 cursor
>>SELECT parts.partno, 0000000000 as qtyused, 0000000000 as qtyrec FROM parts ;
>>	UNION(SELECT partno, qtyused, 000000000 as qtyrec FROM USEDPARTS) ;
>>	UNION(SELECT partno, 0000000000 as qtyused, qtyrec FROM RECEIVED) ;
>>	INTO CURSOR dummy
>>
>>* calculate the sum
>>SELECT partno,sum(qtyused),sum(qtyrec) from dummy GROUP BY 1
>>
>>

>
>This is pretty much how I thought it could be done, with two SQL selects. I wanted to be sure I am not missing some way to pull it all into one SQL select. Not to say that 1 SQL select would always make the query faster.
>
>Thank you for your help.

I am not sure that one complex query is faster than 2 or 3 chained queries.
I think I have read something (where?) that say the opposite.

With a couple of simple queries, its easy to build a rushmore optimizable select...