I am getting the following error when attempting to run a report:

Error #:2111 Message: There is a duplicate table alias 'MasterIndividual' in the FROM clause.

Sure enough, there is.  Here is the SQL statement:

select MasterIndividual.MAS_PK,MasterIndividual.MAS_DOB,MasterIndividual.MAS_DOBDOCUMENTED,MasterIndividual.MAS_EMPLOYERID,WageMasterIndividual.WGM_DATELASTFILED from WageMASTER MasterIndividual inner join MASTER MasterIndividual on WageMasterIndividual.WGM_WEMASTERFK=MasterIndividual.MAS_PK where MasterIndividual.mas_institutionFK = 0 and MasterIndividual.mas_PK > 0

MasterIndividual is a sub-table of Master.dbf

WageMasterIndividual is a sub-table of WageMaster

They are related via WageMasterIndividual.wgm_WEMasterFK = MasterIndividual.mas_PK.

Why is the statement being generated this way? Help!

Thanks!

In order to investigate this issue I will need to see your Stonefield Query project files and a sample database if possible.

The project files consist of:

SFQuery.INI
SFConfig.DBF, FPT, and CDX
SFScript.DBF, FPT, and CDX
RepMeta.DBF, FPT, and CDX

Please zip these files up and send them to support@stonefieldquery.com along with a sample database.

If data security is a concern then you can send me an empty copy of the database.