i am not clear about ur join like
Table1.C# = Table2.I#
Any how it will be solved with this query.
SELECT Count(*) AS [Count]
FROM [SELECT Table2.C#, Table2.I#
FROM Table2
GROUP BY Table2.C#, Table2.I#]. AS table3 INNER JOIN Table1 ON (table3.I# = Table1.I#) AND (table3.C# = Table1.C#);
I...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.