Number : -2147217900 Page : /dealerfiles/DealerList.asp Desc : Incorrect syntax near 'a'. SQL : SELECT a.ListingID,a.idLocation,l.company,a.VIN,a.Description,stockno,caryear,make,cartrim,model,miles,cpo,a.listPrice,a.showprice,enginetype,enginecucc,enginehp,trans,drivetrain,bodytype,extcolor,a.ourprice,a.sold,a.fileName,vehicletype,numbdrm,numbath,numfloor,sqfootageFROM Listings a left join location l on l.idLocation=a.idLocation where a.ListingID in (select ListingID from Manuf_Categories where CategoryID = 6) AND a.active = -1 ORDER BY a.ourprice ASC