>
> In MySQL, I need to do a multi table join in the context of a left
join. Have three
> tables: NAME, ADDRESS, and COUNTRY. Address contains a country code
(ie
> "CAN") and COUNTRY contains the translation (ie Canada). What I'd
like to
> do is get all NAMES
of: The distribution of data in your tables affect
the join optimizer. Consider a multi-table join with this condition:
WHERE ... firstname.name = 'Roger' and lastname.name = 'Baklund'
...and the same statement with this condition:
WHERE ... firstname.name = 'Roger'
Josh Trutwin wrote:
>The first query averages about 0.085 seconds from the mysql prompt, the
>second about 0.075 seconds and the 3rd 0.065 seconds.
>
>Thanks for some great advice, this has been bugging me for a while!
>
>
Its well appreciated to see examples of what works and what doesn't too;
Here is the query that I had in a PhP script that joins a bunch of
tables (I'll try to make this look readable). If you're curious, it's for
a motorcross site (www.springcreekmx.com):
SELECT standings.rank, race.race_date, class.class_name,
racer.racer_name, cycle.cycle_desc, race_event.racer_
x27;t
missed.
- Original Message -
From: "Bob Hall" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, February 04, 2001 12:48 PM
Subject: Re: Problem with Match / Against and multi-table join
> >I am trying to write a query using the fulltext and match
>I am trying to write a query using the fulltext and match and I've
>run into a problem. I'm new to MySQL, so this question might have
>already been asked, but I just can't seem to find it.
>
>I'm using the fulltext capabilities to do a query. The query
>requires joins with four different tab
I am trying to write a query using the fulltext and match and I've run into a problem.
I'm new to MySQL, so this question might have already been asked, but I just can't
seem to find it.
I'm using the fulltext capabilities to do a query. The query requires joins with four
different tables.
