Classic ASP Discussion - sql Inner Join problem

Print Page | Close Window

sql Inner Join problem

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=14634
Printed Date: 30 March 2026 at 6:38am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: sql Inner Join problem

Posted By: ub3rl337ch3ch
Subject: sql Inner Join problem
Date Posted: 11 April 2005 at 12:05am

I'm trying to execute the following sql:

sql = "UPDATE BRSched INNER JOIN (Invoice INNER JOIN BrProp ON Invoice.Propno = BrProp.PropNo) ON (BRSched.Version = BrProp.schedno) AND (BRSched.Propno = BrProp.fmPropNo) SET BRSched.Invno = Invoice.Invno WHERE BRSched.Invno = 0 AND BrProp.PropNo ='" & radio & "' AND Invoice.PropType='Broadacre'"

but it is being very unhelpful and giving me the following error:

Microsoft OLE DB Provider for SQL Server (0x80040E14)
Incorrect syntax near the keyword 'INNER'.

this query is derived from a working access 2003 query, as follows:

"UPDATE BRSched INNER JOIN (Invoice INNER JOIN BrProp ON Invoice.Propno = BrProp.PropNo) ON (BRSched.Version = BrProp.schedno) AND (BRSched.Propno = BrProp.fmPropNo) SET BRSched.Invno = [invoice].[invno] WHERE (((BRSched.Invno)=0) AND ((BrProp.PropNo)=[forms]![CLIENT].[vpno]) AND ((Invoice.PropType)='Broadacre'));"

I've converted the access references (ie the [forms]![CLIENT].[vpno] type stuff) to the appropriate references, but as you can see I haven't touched first part. Is there anything i should know about asp getting narky about 'inner join'?