Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
inner join problem
Hi PH, Thanks for your prompt response. I'm afraid The syntax error remains... Microsoft JET Database Engine error '80040e14' Syntax error in JOIN operation. /forum/esd-servresults-new.asp, line 198- eurosytes
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
inner join problem
Hi there, I have a problem with the syntax for a multi-table inner join which I hope someone can help me with. My SQL statement looks like this.... "SELECT orgs.documentref, mainser.name, ser.name, orgs.datein, serorgs.serid, orgs.title, orgs.shortdesc, orgs.webaddress, serorgs.webaddress...- eurosytes
- Thread
- Replies: 2
- Forum: Microsoft: Access Queries and JET SQL
