Hi, I am having problems with the following query: I am trying to join Tax_Bands and Property_Types to Properties but the query seems to be joning Tax_Bands to Properties.
SELECT P.*, Tax_Band, Property_Type FROM Properties P INNER JOIN Tax_Bands USING(Tax_Band_ID) INNER JOIN Property_Types USING(Property_Type_ID) WHERE P.Property_ID = 3 Here is the error message I am getting: Unknown column 'Tax_Bands.Property_Type_ID' in 'on clause' Thanks for your advice. # ---------- MySQL dump ---------- # # Table structure for table 'Properties' # CREATE TABLE Properties ( Property_ID int(11) DEFAULT '' NOT NULL auto_increment, Property_Name_Or_Number varchar(50) , Address_Line_1 varchar(50) , Address_Line_2 varchar(50) , City varchar(50) , County varchar(50) , Postcode varchar(12) , Sale_Price int(11) , Asking_Price int(11) , Years_On_Lease int(11) , Tax_Band_ID int(11) , Property_Type_ID int(11) , Number_Of_Bedrooms int(11) , Number_Of_Bathrooms int(11) , Number_Of_Receptions int(11) , Internal_Square_Footage int(11) , Internal_Square_Meters int(11) , Price_Per_Square_Foot decimal(6,2) , Price_Per_Square_Meter decimal(6,2) , Additional_Notes text , PRIMARY KEY (Property_ID) ); # # Table structure for table 'Property_Types' # CREATE TABLE Property_Types ( Property_Type_ID int(11) DEFAULT '' NOT NULL auto_increment, Property_Type varchar(50) , PRIMARY KEY (Property_Type_ID) ); # # Table structure for table 'Tax_Bands' # CREATE TABLE Tax_Bands ( Tax_Band_ID int(11) DEFAULT '' NOT NULL auto_increment, Tax_Band varchar(50) , PRIMARY KEY (Tax_Band_ID) ); # ----------- Dump ends ----------- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
