sql server programming: Hi waht is the syntax for the above, this only return 1 row instead of
3. Thanks.
Each table has dteExported column. Thanks.

select count(*) from tblA WHERE DateDiff(d,dteExported,GetDate())>1)
UNION
select count(*) from tblB WHERE DateDiff(d,dteExported,GetDate())>1)
UNION
select count(*) from tblC WHERE DateDiff(d,dteExported,GetDate())>1)

There is a good chance that all the queries in the union get the same
results. Since the default for union query is to return distinct rows
only, you are getting only 1 row. If you'll modify the query and
instead of union, you write union all, you'll get 3 rows.

Of course this brings up another question - Are you sure that this is
the result set that you want? If you'll just get 3 numbers then how
would you know which number belongs to which query? I would modify the
query and add a constant in each query in the union that will contain
the table's name so I'll know which row came from which query in the
union

Adi


[quoted text, click to view]