Shaik Ali

Shaik Ali

  • NA
  • 46
  • 872

Converting two Select Querys into One Query

Jun 28 2019 12:17 AM
Dear Experts
 
Can you please suggest
 
How do i Convert the following two queries into one query
 
(SELECT SUM(Qty+QtyFree) AS TOT_IN
FROM detail AS D
WHERE TTYPE IN ('P','R','T')
GROUP BY BID),
(SELECT SUM(Qty+QtyFree) AS TOT_OUT
FROM detail
WHERE TTYPE IN ('S','B','A')
GROUP BY BID)
 
 
 
THANKS 

Answers (5)