How to find persons who like red fruits or crunchy veggies?
From: Neo <neo55592_at_hotmail.com>
Date: 14 Nov 2006 21:16:09 -0800
Message-ID: <1163567769.094420.249340_at_f16g2000cwb.googlegroups.com>
The following dbd query finds persons who like either red fruits or crunchy veggies:
)
Date: 14 Nov 2006 21:16:09 -0800
Message-ID: <1163567769.094420.249340_at_f16g2000cwb.googlegroups.com>
The following dbd query finds persons who like either red fruits or crunchy veggies:
(and (select person instance *)
(select * like (or (and (select fruit instance *)
(select * color red))
(and (select veggie instance *)
(select * texture crunchy))
)
)
)
What RMDB schema and SQL query will find the equivalent? Should I start with T_Person, T_Fruit, T_Veggie, T_PLikeF, T_PLikeV ? Received on Wed Nov 15 2006 - 06:16:09 CET