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
05, 2004 4:59 PM
Subject: Advanced SELECT Syntax Help Needed!
Hi!
I would love some help with my syntax (or another strategy). I keep bombing.
I've simplified it. Here is the deal:
Three files:
Main: id, name
Links1: id, linkname1 (a record may or may not exist for each record in
Main)
Hi!
I would love some help with my syntax (or another strategy). I keep bombing.
I've simplified it. Here is the deal:
Three files:
Main: id, name
Links1: id, linkname1 (a record may or may not exist for each record in
Main)
Links2: id, linkname2 (a record may or may not exist for each re
