SELECT c.*, man.*, mo.ModelID, mo.ManufacturerID, mo.ModelName, f.*, co.* FROM tblcars c INNER JOIN tblmanufacturer man ON (c.ManufacturerID = man.ManufacturerID) INNER JOIN tblmodel mo ON (c.ModelID = mo.ModelID) INNER JOIN tblfuel f ON (c.FuelID = f.FuelID) INNER JOIN tblcolours co ON (c.ExteriorColourID = co.ColourID) WHERE ShowOnSite=1 AND Price BETWEEN ManufacturerName,ModelName AND <br />1064: 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 'ModelName AND' at line 1