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.
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.