hi Friends,
i have written query like below:
SELECT Sum1,Sum2,Sum3,Sum4,Sum5,Sum6,Sum7,Sum8,Sum9,Sum10,Sum11,Sum1+Sum2+Sum3+Sum4+Sum5+Sum6+Sum7+Sum8+Sum9+Sum10+Sum11 as Total
FROM
(SELECT SUM(Points) as Sum1 FROM tblClassifieds
WHERE Author='Vanchi') T1 CROSS JOIN
(SELECT SUM(Points) as Sum2 FROM tblCollege
WHERE Author='Vanchi') T2 CROSS JOIN
(SELECT SUM(Points) as Sum3 FROM tblForum
WHERE Author='Vanchi') T3 CROSS JOIN
(SELECT SUM(Points) as Sum4 FROM tblForumResponse
WHERE responseby='Vanchi') T4 CROSS JOIN
(SELECT SUM(Points) as Sum5 FROM tblKnowledge
WHERE Author='Vanchi') T5 CROSS JOIN
(SELECT SUM(Points) as Sum6 FROM tblmusicinfo
WHERE Author='Vanchi') T6 CROSS JOIN
(SELECT SUM(Points) as Sum7 FROM tblpostjob
WHERE Author='Vanchi') T7 CROSS JOIN
(SELECT SUM(Points) as Sum8 FROM tblRecipe
WHERE Author='Vanchi') T8 CROSS JOIN
(SELECT SUM(Points) as Sum9 FROM tblSchool
WHERE Author='Vanchi') T9 CROSS JOIN
(SELECT SUM(Points) as Sum10 FROM tblUniversity
WHERE Author='Vanchi') T10 CROSS JOIN
(SELECT SUM(Points) as Sum11 FROM tblwavesinfo
WHERE Author='Vanchi') T11
but the result was displayed like below:
Sum1 Sum2 Sum3 Sum4 Sum5 Sum6 Sum7 Sum8 Sum9 Sum10 Sum11 Total
-------------------------------------------------------------------------------------------------------------------------------------------
5 6 12 NULL 12 NULL NULL 6 6 4 2 NULL
here Total was diaplayed as NULL
but i want to show the Total=53 anybody tell the procedure of query
Thanks in Advance
Thanks
tvn