SELECT tblinventory.invId, tblinventory.invTitle, tblinventory.InvImage, tblinventory.invStatus, tblhouseinfo.City, tblhouseinfo.State, tblhouseinfo.Make, tblhouseinfo.Model, tblhouseinfo.sqr_ft, tblhouseinfo.BedRooms, tblhouseinfo.BathRooms, tblhouseinfo.list_price, tblinvtype.typeName FROM tblinventory LEFT OUTER JOIN tblhouseinfo ON tblinventory.invId = tblhouseinfo.addInfoID LEFT OUTER JOIN tblinvtype ON tblinventory.invType = tblinvtype.typeId WHERE tblinventory.mid = 1 AND tblinventory.invStatus IN (6,8,9)) AND tblinventory.type = '-1' ORDER BY tblhouseinfo.City ASC<BR><BR>You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND tblinventory.type = '-1' ORDER BY tblhouseinfo.City ASC' at line 1