I need to right a query that list items with matching fields. So I have a database that list a bunch of colors. The database looks likes this:
ID Color
1 Black
2 Red
And then another table list a bunch of product like this:
ID Product Color
1 Tee- Shirt Red
2 Pants Red
3 Coat Red
I need the Query to look like this:
Color Item1 Item2 Item 3
So out put would be
Red Tee-Shirt Pants Coat
NOt sure how to do this except its similar to a cross tab. Any help.
ID Color
1 Black
2 Red
And then another table list a bunch of product like this:
ID Product Color
1 Tee- Shirt Red
2 Pants Red
3 Coat Red
I need the Query to look like this:
Color Item1 Item2 Item 3
So out put would be
Red Tee-Shirt Pants Coat
NOt sure how to do this except its similar to a cross tab. Any help.
