asked
SQl query
how to get the count from two different tables based on some where condition with single query
Please supply some more details about your tables and the condition you want to apply
This site works on the concept of votes. For each of the answers below that was helpful you should indicate this by clicking on the thumbs up next to those answers. If anyone of the answers below helped solve your problem you can indicate that by clicking on the check mark next to that answer.
Without an example I can only offer general advice. In order to get a count from each table, you'll need to query each table individually. However, you can combine the output. One mechanism would be to use a [UNION query][1]. [1]:
http://msdn.microsoft.com/en-us/library/ms180026.aspx
You could create a view over the two tables and query that for the rowcount... Assuming the tables have compatible fields (or you can make an appropriate subset of fields). eg: CREATE VIEW MyView AS SELECT ID, Field1, Field2, CreatedDate FROM Table1 UNION SELECT ID, Field3 AS Field1, Field4 AS Field2, CreatedDate FROM Table2 and then SELECT COUNT(*) FROM MyView WHERE CreatedDate >= '2013-01-01' AND CreatedDate
Grant and Thomas answers are correct, but you need to use UNION ALL to get all records from both tables, otherwise you'll get only distinct records. UNION is often abused where UNION ALL can be used to increase performance.
100% correct. Good addition. Without details, hard to know if it's what's needed or not.
There are multiple ways to do this. You can UNION the two tables together and do the condition on that if you're looking for a single answer. Another method, if you're looking for a comparison is to use sub-queries. SELECT (SELECT COUNT(*) FROM TableA WHERE Condition) TableA, (SELECT COUNT(*) FROM TableB WHERE Condition) TableB
19 People are following this question.
