Select Acode, Image, Year, DivDesc, ModelDesc, RealTrim, TrimDesc, VarDesc, MSRP = MSRP + DestinationCharge + 695.00 from vwNewVehicleShowroom where ModelId in (select ModelId from vwNewVehicleShowroom where Acode='CAC70CHS341A0' and LngCode='EN') and RealTrim<>'' and BodyStyle ='' and Lngcode='EN' and Year = Order By RealTrim, MSRPIncorrect syntax near the keyword 'Order'.