以下語句提示出錯,該如何寫?(PURTC,PURTD為主從表關系,求不重復的主表記錄數)
Select Count(distinct A.* ) As TOTALCOUNT FROM PURTC AS A ,PURTD WHERE A.TC001=TD001 AND A.TC002=TD002
Select Count(distinct A.* ) As TOTALCOUNT FROM PURTC AS A ,PURTD WHERE A.TC001=TD001 AND A.TC002=TD002
FROM PURTC AS A ,
PURTD WHERE A.TC001=TD001
AND A.TC002=TD002
FROM PURTC AS A ,PURTD
WHERE A.TC001=TD001 AND A.TC002=TD002
(Select distinct A.* As TOTALCOUNT FROM PURTC AS A JOIN PURTD ON A.TC001=TD001 AND A.TC002=TD002)AS T??
from(
Select distinct * FROM PURTC AS A ,PURTD WHERE A.TC001=TD001 AND A.TC002=TD002) t