Problem with INNER JOIN SQL statement

[Paul Cooper]

I have two tables and am trying to do an inner join and getting this error message:


Not unique table/alias: 'tblClients'


These are my two tables:

tblClients
- ClientID
- LicenseeID
- CreationDate
- EmailAddress
- FirstName
- LastName
- Company

tblResults
- ResultID
- GroupID
- ClientID


This is the SQL statement causing the error:

strSQL = "SELECT tblClients.ClientID, tblClients.LicenseeID, tblClients.CreationDate, tblClients.EmailAddress, tblClients.FirstName, tblClients.LastName, tblClients.Company, tblResults.ResultID, tblResults.GroupID, tblResults.ClientID FROM tblClients INNER JOIN tblClients ON tblResults.ClientID = tblClients.ClientID WHERE tblClients.LicenseeID = " & strID & ";"

What I’m trying to do is get all the data from tblClients and then when I loop through them later see if there is an entry for each ClientID in tblResults.

Can someone point out where I’m going wrong with my SQL statement?

TIA
Paul