Query returning same field value from two diffenrent tables

[NielsE]

In the following query that is the source for a list box:
SELECT tblPROJECTS.Projectsymbol, tblPROJECTS.Title, tblPROJECTS.StatusDate,
tblPROJECTS.Budget, tblPROJECTS.Projectdocument, tblPROJECTS.Status,
tblPROJECTS.Region, tblProjectSubject.SubjectName, tblPROJECTS.ProjectID, *
FROM tblPROJECTS INNER JOIN tblProjectSubject ON tblPROJECTS.ProjectID =
tblProjectSubject.ProjectID;
I get the ProjectID returned from both tblProjects and tblProjectSubject,
which gives me an error message when i open the form.
Can somebody please tell why and what i should change to get the query right.
Thanks.
Niels

 

[OfficeDev18 via AccessMonster.com]

I think you need to remove the '*' at the end of the SELECT clause. If you
really want all fields from tblProjects, get rid of all the detail fields in
the SQL statement and just keep the '*' and the one field from
tblProjectdocument.