Query returning same field value from two diffenrent tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Back
Top