Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
-Dman100-
Posting Yak Master
210 Posts |
Posted - 2006-09-14 : 11:23:04
|
I'm getting a Syntax error in JOIN operation.This is the statement:strSQL = "select currentstatus.status, currentstatus.image, StatusHeader.Url, StatusDescription.Description " & _"from ((StatusDetails inner join CurrentStatus on statusDetails.currentstatus = currentstatus.statusid) " & _"(inner join StatusHeader on statusDetails.statusheader = statusheader.HeaderId " & _"inner join StatusDetails on StatusDetails.StatusDescription = StatusDescription.DescriptionId)) " & _"where statusdetails.sitename = '" & arg1 & "'"If I remove the last inner join the statement runs fine:strSQL = "select currentstatus.status, currentstatus.image, StatusHeader.Url " & _"from ((StatusDetails inner join CurrentStatus on statusDetails.currentstatus = currentstatus.statusid) " & _"inner join StatusHeader on statusDetails.statusheader = statusheader.HeaderId) " & _"where statusdetails.sitename = '" & arg1 & "'"Any help is appreciated.Thank you. |
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-09-14 : 11:29:46
|
[code]select currentstatus.status, currentstatus.image, StatusHeader.Url, StatusDescription.Descriptionfrom StatusDetailsinner join CurrentStatus on statusDetails.currentstatus = currentstatus.statusidinner join StatusHeader on statusDetails.statusheader = statusheader.HeaderIdinner join StatusDescription StatusDetails on StatusDetails.StatusDescription = StatusDescription.DescriptionIdwhere statusdetails.sitename = @arg1[/code]Peter LarssonHelsingborg, Sweden |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-09-15 : 10:27:06
|
Also use stored procedures with parameters. Avoid having concatenated sql statementsMadhivananFailing to plan is Planning to fail |
|
|
|
|
|