* Michael T. Babcock
Its well appreciated to see examples of what works and what doesn't too;
its nice to know how to get one's queries in an order that makes the
MySQL optimizer's life easier. I'm trying to decide if there's some
logical way to inform MySQL that it can reorder a series of
right. corereader is designed to query all
platforms from an ms. windows frontend.
Thanks John,
I looked through your web site, it seems to me that corereader is
microsoft based product. I'm on Linux RedHat 7.2.
thanks
[EMAIL PROTECTED] wrote:
corereader will help you
right. it also won't run on mainframes. :)
corereader is designed to query all platforms from
an ms. windows frontend.
Thanks John,
I looked through your web site, it seems to me that corereader is
microsoft based product. I'm on Linux RedHat 7.2.
thanks
[EMAIL PROTECTED]
Is there a document that compiles examples on different ways of joining
two or more tables? I found a few on
http://www.mysql.com/doc/en/JOIN.html but they do not cover joining more
than two tables.
Thanks for any suggestions.
Is there a document that compiles examples on different ways of joining
two or more tables? I found a few on
http://www.mysql.com/doc/en/JOIN.html but they do not cover joining more
than two tables.
Thanks for any suggestions.
I wish there were more examples as well!
I use this for
- Original Message -
From: damovand [EMAIL PROTECTED]
To: mysql [EMAIL PROTECTED]
Sent: Thursday, October 03, 2002 12:31 PM
Subject: Is there Examples and Documents on joining tables?
Is there a document that compiles examples on different ways of joining
two or more tables? I found a few
corereader will help you do a pointclick join of up
to four tables.
you can operate corereader without it, but reading
the documentation is strongly recommended.
Is there a document that compiles examples on different ways of joining
two or more tables? I found a few on
within it).
Then you can inspect the code it writes and tweak it to suit using EXPLAIN.
hth,
Arthur
- Original Message -
From: damovand [EMAIL PROTECTED]
To: mysql [EMAIL PROTECTED]
Sent: Thursday, October 03, 2002 12:31 PM
Subject: Is there Examples and Documents on joining tables
PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, October 03, 2002 3:57 PM
Subject: Re: Is there Examples and Documents on joining tables?
Is there a document that compiles examples on different ways of joining
two or more tables? I found a few on
http://www.mysql.com/doc/en/JOIN.html
Josh Trutwin wrote:
SELECT table1.bunch, table2.of, table3.stuff FROM table1
INNER JOIN table2 ON table2.some_id
INNER JOIN table3 ON table3.some_id
WHERE table1.some_id = table2.some_id AND table1.some_id =
table3.some_id;
Your where is sort of in the wrong place ...
SELECT
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,
Thanks John,
I looked through your web site, it seems to me that corereader is
microsoft based product. I'm on Linux RedHat 7.2.
thanks
[EMAIL PROTECTED] wrote:
corereader will help you do a pointclick join of up
to four tables.
you can operate corereader without it, but reading
: Thursday, October 03, 2002 8:08 PM
Subject: Re: Is there Examples and Documents on joining tables?
Hi Arthur,
Thanks for your answer and your example. Your example is very good but I
can't map to what I'm trying to do. As you suggested I have to
understand how inner join is implemented in MySQL
13 matches
Mail list logo