problem with join SQL Server 2000
- by eyalb
I have 3 tables -
Items,
Props,
Items_To_Props
i need to return all items that match all properties that i send
example
items
1
2
3
4
props
T1
T2
T3
items_to_props
1 T1
1 T2
1 T3
2 T1
3 T1
when i send T1,T2 i need to get only item 1