anced SELECT Syntax Help Needed!
On Fri, 5 Nov 2004 17:49:29 -0500, Rhino <[EMAIL PROTECTED]> wrote:
> I'm not sure why you want to use a subquery; if MySQL is anything like
DB2,
> a join usually performs better than a subquery and the optimizer converts
a
> subquery to
On Fri, 5 Nov 2004 17:49:29 -0500, Rhino <[EMAIL PROTECTED]> wrote:
> I'm not sure why you want to use a subquery; if MySQL is anything like DB2,
> a join usually performs better than a subquery and the optimizer converts a
> subquery to a join ("under the covers") whenever it can anyway. Therefore
I'm not sure why you want to use a subquery; if MySQL is anything like DB2,
a join usually performs better than a subquery and the optimizer converts a
subquery to a join ("under the covers") whenever it can anyway. Therefore,
how about something like:
select id, name, linkname1, linkname2
from ma
