Help me with Query please

[fordtran]

I have a table 'projecttasks' which has a field 'projectno' referring to a project in the projects table with a 'projectname' field.
The 'projecttasks' table also has a field 'subbieno' referring to a subbie number in the subbie table with a 'subbiename' field.
I want to extract a record for a specific projecttask and add the projectname and subbiename to that recordset.
I have unsuccessfully tried :

S$="SELECT projecttasks.*, projects.projectname, subbies.subbiename FROM projecttasks INNER JOIN projects ON projecttasks.projectno=projects.projectno INNER JOIN subbies ON projecttasks.subbieno=subbies.subbieno WHERE projects.projectname='" & MyProjectName & "' AND subbies.subbiename='" & MySubbiename & "'"

Can someone PLEASE help
Thanks

fordtran

 

[Remou]

How about:
[tt]S$="SELECT projecttasks.*, projects.projectname, subbies.subbiename FROM (ProjectTasks INNER JOIN Projects ON ProjectTasks.ProjectID = Projects.ProjectID) INNER JOIN Subbies ON ProjectTasks.SubbieNo = Subbies.SubbieNo WHERE projects.projectname='" & MyProjectName & "' AND subbies.subbiename='" & MySubbiename & "'"[/tt]

 

[fordtran]

Thank you very much. I eventually managed to get it as you have suggested.

fordtran