Re: Multiple INNER JOINS

On 10/19/05, Peter Brawley wrote: 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. That query generates no error in 5.0.13. There have been several cascading join bugs,

Multiple INNER JOINS

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

Re: Multiple INNER JOINS

Shaun, 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. That query generates no error in 5.0.13. There have been several cascading join bugs, some fixed, some not. What

Re: Multiple INNER JOINS

Hi Peter, I am using version 3.23.54, unfortunately I have no control over this :( Peter Brawley [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Shaun, I am having problems with the following query: I am trying to join Tax_Bands and Property_Types to Properties but the query seems

Re: Multiple INNER JOINS

It looks like MySQL is interpreting your short form join syntax a different way than you expect. Try using the long form by specifying which tables and fields you want to join. SELECT ... FROM Properties P INNER JOIN Tax_Bands ON P.Tax_Band_ID=Tax_Bands.Tax_Band_ID INNER JOIN Property_Types

Re: Multiple INNER JOINS

Hi Shaun, I don't have a 3.23 installation to test it on just now. If Brent's suggestion fails, try changing the join pattern to tb INNER JOIN p INNER JOIN pt (if you can't beat it, join it :-) ). PB - Shaun wrote: Hi Peter, I am using version 3.23.54, unfortunately I have no

Multiple INNER JOINs

Can I just check: should it be OK to do multiple INNER JOINs like this: SELECT * FROM (((table1 INNER JOIN table2 ON table1.anyfield = table2.anyfield) INNER JOIN table3 ON table3.anyfield=table2.anyfield) INNER JOIN table4 on table4.anyfield=table1.anyfield) WHERE... Regards, John sql,query

Re: Multiple INNER JOINs

On 5 Jul 2002, at 18:27, Dillon, John wrote: Can I just check: should it be OK to do multiple INNER JOINs like this: SELECT * FROM (((table1 INNER JOIN table2 ON table1.anyfield = table2.anyfield) INNER JOIN table3 ON table3.anyfield=table2.anyfield) INNER JOIN table4 on table4.anyfield