thank you
- Original Message -
From: "Jay Pipes" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc:
Sent: Tuesday, March 06, 2007 4:29 AM
Subject: Re: help me optimize this "ALL"
> No, because you have no WHERE condition.
>
No, because you have no WHERE condition.
wangxu wrote:
> sql:
>
> SELECT *
> FROM table_one INNER JOIN table_one table_one1 ON table_one1.column_one =
> table_one.column_two
>INNER JOIN table_one table_one2 ON table_one2.column_one =
> table_one.column_three
sql:
SELECT *
FROM table_one INNER JOIN table_one table_one1 ON table_one1.column_one =
table_one.column_two
INNER JOIN table_one table_one2 ON table_one2.column_one =
table_one.column_three
explain:
*** 1. row **
