Thursday, 25 July 2013

Query to Combine Columns from two select statements

Select t1.B1,  t2.B2
From
(Select Sum (CourseFee) as B1
FROM STUDENTMASTER
where ADMNNO=100081) t1
,
(Select Sum (Amount) as B2
FROM FeeConcession
where ADMNNO=100081) t2

No comments:

Post a Comment