Print Page | Close Window

SQL Server error ’80040e14’

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=16281
Printed Date: 30 March 2026 at 1:18am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: SQL Server error ’80040e14’
Posted By: ub3rl337ch3ch
Subject: SQL Server error ’80040e14’
Date Posted: 21 August 2005 at 11:43pm
Microsoft OLE DB Provider for SQL Server error '80040e14'

Incorrect syntax near the keyword 'INNER'.

This error spits at me when i try to execute the following sql using adoCon.execute sql
 
 
sql = "UPDATE BRSched INNER JOIN (Invoice INNER JOIN BrProp ON Invoice.Propno = BrProp.PropNo) ON (BRSched.Propno = BrProp.fmPropNo) AND (BRSched.Version = BrProp.schedno) SET BRSched.Invno = invoice.invno WHERE (((BRSched.Invno)=0) AND ((BrProp.PropNo)='417') AND ((Invoice.PropType)='Broadacre')) "
 
The sql works in access with no issues, but completely refuses to run in my asp app. Any ideas?
 
btw: the access db i'm running it in is a front-end for the same mssql back-end as i'm using in my app.



Replies:
Posted By: wingking
Date Posted: 26 August 2005 at 3:15pm
well I am far from an SQL wiz but I get by on own. so I may be mistaken but I don't believe inner joins are valid in sql. access is so gone in my past I barely recall working with it.
however you can accomplish a join by doing where...
update * where tbl.field = tbl.field
I hope that helps.



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net