select distinct A.Field1 as ACN,
(select count(Field1) from ssfields where ArchiveID = '1' and Field1=A.Field1) as Row_Count_1,
(select count(Field1) from ssfields where ArchiveID = '5' and Field1=A.Field1) as Row_Count_5,
(select count(Field1) from ssfields where ArchiveID = '8' and Field1=A.Field1) as Row_Count_8
from ssfields A
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment