generally simplify this?
R.
-Original Message-
From: Robert DiFalco [mailto:[EMAIL PROTECTED]
Sent: Friday, August 04, 2006 4:12 PM
To: [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Subject: RE: Query Help for Loosely Couple Properties
I think this only works if I know that Orange
, 2006 9:37 AM
To: Robert DiFalco
Cc: mysql@lists.mysql.com
Subject: Re: Query Help for Loosely Couple Properties
On Tue, 2006-08-01 at 16:23 -0700, Robert DiFalco wrote:
The question is, how do I query this? Say I want all records from
table T whose COLOR property value is ORANGE.
The only
They are user defined properties.
-Original Message-
From: Jay Pipes [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 01, 2006 8:11 PM
To: Robert DiFalco
Cc: mysql@lists.mysql.com
Subject: Re: Query Help for Loosely Couple Properties
On Tue, 2006-08-01 at 16:23 -0700, Robert DiFalco
On Tue, 2006-08-01 at 16:23 -0700, Robert DiFalco wrote:
The question is, how do I query this? Say I want all records from table
T whose COLOR property value is ORANGE.
The only thing I can come up with (and I'm no SQL expert and this looks
wrong to me) is the following:
SELECT *
FROM T
I have a table that contains properties that can be associated with any
table whose primary key is a LONG. Lets say that there is just one kind
of property. The table looks something like this:
TABLE StringVal
REF_ID BIGINT// row to associate property with
TYPE_ID BIGINT
On Tue, 2006-08-01 at 16:23 -0700, Robert DiFalco wrote:
I have a table that contains properties that can be associated with any
table whose primary key is a LONG. Lets say that there is just one kind
of property. The table looks something like this:
TABLE StringVal
REF_ID BIGINT