Subqueries again - rajeevnandanmishra!!!!

[ADW]

Hello, me again, nearly what I'm after although I don't think it's possible to achieve what I want to achieve.

I want to return all rows of 'issu' AND 'recpt' in the same statement, but seperatley! Can't do it can I?

 

[rajeevnandanmishra]

Hi adw,

What i understand from your tip is you want something like this


select a.warehouse as 'WAREHOUSE' , a.transaction_type,a.cnt as cntA, b.transaction_type, b.cnt as cntB
FROM (select warehouse, transaction_type, count(*) as cnt from strip group by warehouse, transaction_type) A ,
(select warehouse, transaction_type, count(*) as cnt from strip group by warehouse, transaction_type) B
WHERE a.warehouse=b.warehouse and a.transaction_type>b.transaction_type


Execute this, and please let me know if it works.

 

[rajeevnandanmishra]

Hi adw,
Sorry i missed one thing, If you have more than two type of transaction_type then include transaction_type in ('issu','rece') in both inner query's where condition.