Hello. Table 1: Items id, Name
Table 2: Properties id, Item, Name, Value
I want select Items _and_ all thier props only if Item have specified property.
Example: Table Item: 1, Mouse 2, Monitor 3, Keyboard
Table Properties: 1, 1, Color, Red 2, 2, Color, Gray 3, 1, Interface, Wireless 4, 2, MaxResolution, [EMAIL PROTECTED] 5, 3, Color, Gray 6, 3, NumberOfKeys, 101
I want select all Items and all thier properties if item's Color is Gray: Item, Name, Prop, Value 2, Monitor, Color, Gray 2, Monitor, MaxResolution, [EMAIL PROTECTED] 3, Keyboard, Color, Gray 3, Keyboard, NumberOfKeys, 101
I hope you've understand what I mean. Thanks. Ruslan.
PS: MySQL 4.0.x
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]