Trying to retrive a report from the DataBase using left join on two tables. To get the count of resultant table, I'm using count. But the output shows error. If I comment count statement then the query executes successfully.
I feel there is some error in the syntax of the count that I'm using.
Please give me the exact syntax for both count as well as inner join.
Thanks in advance.
MS SQL 2005
July 27, 2010 11:13 AM
July 27, 2010 4:04 PM