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

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 contr

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_Typ

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 s

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

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 USI

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 JOI

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