Mike Johnson wrote:
From: Ruslan U. Zakirov [mailto:[EMAIL PROTECTED]
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
Tab
From: Ruslan U. Zakirov [mailto:[EMAIL PROTECTED]
> 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
>
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, Wirel