Ripal Merakinfoway wrote:
but this query are give me a sum of three table but i have answer like 20 25 20
In that case, change the query to:
SELECT ( CONVERT(VARCHAR, (SELECT COUNT(*) FROM history)) + ' ' + CONVERT(VARCHAR, (SELECT COUNT(*) FROM appointment_info)) + ' ' + CONVERT(VARCHAR, (SELECT COUNT(*) FROM DailyIncome)) )