Say I have only one table:
Table1
ID Name
1 John
2 Tom
3 Fred
4 Sam
5 Max
6 Wilbur
I want to display a report with 2 groups:
"Red" and "Green"
I know that Red should have 1,2,3 and Green should have 1,4,5
How do I show John on both Red and Green?
I don't care about Wilbur.
Table1
ID Name
1 John
2 Tom
3 Fred
4 Sam
5 Max
6 Wilbur
I want to display a report with 2 groups:
"Red" and "Green"
I know that Red should have 1,2,3 and Green should have 1,4,5
How do I show John on both Red and Green?
I don't care about Wilbur.