Select Count (Distinct....)

[goterps1]

I'm recieving a missing operator error on the select statment when attempting to run the following sql. Can you help?

SELECT COUNT(DISTINCT [Fund 49].SSN) AS Expr1 INTO [Matching 49]
FROM [Fund 49], [Fund 83]
WHERE ((([Fund 49].SSN)=[Fund 83].SSN));

 

[gmmastros]

Is this for an Access database. This forum is specifically for Microsoft SQL Server.

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[kss444]

Try this:

SELECT COUNT(DISTINCT ([Fund 49].SSN)) AS Expr1 INTO [Matching 49]
FROM [Fund 49], [Fund 83]
WHERE [Fund 49].SSN)=[Fund 83].SSN