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.
Topic Options
Post Options
Thanks(0)
