I am receiving error msg on the below query line as "incorrect syntax near MSF" , "Incoorect syntanx near ExtCost", "incorrect syntax near From on line 28"SELECT xxxcolumns, (rj.RECEIVEDLINEAL * ((r.WIDTH / 12.0)) / 1000.0 MSF, Case when rv.PricePerCode = 'MSF' Then ((rj.RECEIVEDLINEAL * (r.WIDTH / 12.0)) / 1000.0) * rv.price Else (rj.RECEIVEDWEIGHT) * rv.price end ExtCost,xxxcolumns1, ( SELECT tablename.columnName FROM tablename ) FROM tablename1 rj ---line 28inner join ....
please help fixing those three errors.