Hello,
I need a help here for SQL statements.
How do I count multiple records from the multiple queries?
I have 4 queries that I want to count how many records are in each query. I want 4 values as the return values.
SELECT Count() AS Value1, Count() AS Value2, Count() AS Value3, Count() AS Value4 FROM query1, query2, query3, query4
If I do this, it returns large values that are identical for all 4 values.
Thanks in advance.
