Friday, August 18, 2006 12:37 PM
To: Robert DiFalco; 'mysql@lists.mysql.com'
Subject: RE: More query help for user-defined values
No takers?
-Original Message-
From: Robert DiFalco
Sent: Thursday, August 17, 2006 3:03 PM
To: Robert DiFalco; mysql@lists.mysql.com
Subject: RE: More query
No takers?
-Original Message-
From: Robert DiFalco
Sent: Thursday, August 17, 2006 3:03 PM
To: Robert DiFalco; mysql@lists.mysql.com
Subject: RE: More query help for user-defined values
One simple solution is to denormalize a little and take the refTypeID
column out of StringValue and
One simple solution is to denormalize a little and take the refTypeID
column out of StringValue and add it to the Links table. Then I could
have:
SELECT P.*
FROM Person P
LEFT JOIN StringLinks L1 ON P.ID = L1.parentID AND L1.refTypeID = 1
LEFT JOIN StringValue SV1 ON L1.valueID
Hi.
On Wed 2002-06-05 at 13:37:22 -0500, [EMAIL PROTECTED] wrote:
[...]
> It selects a list of all members from the database referred by a certain
> member. However, the query needs to be modified to also select the
> number of people that person has referred. I planned to just send
> another que
