I aksed a similar question a while ago, but need my SQL to do 1 more thing.
1 table (T1) and 2 fields (c1 and c2). Table lists matching colors, so rows are:
red blue
red white
blue red
black red
blue green
Original SQL filtered out the doubles – so in this case 4 rows would be returned (red,blue is the same as blue,red). The additional step is to [a] prompt user to enter color, then [b] display all matching colors. So if user enters “red” a list is returned showing “blue, white, black”. If user entered “blue”, the returned list would be “red, green”.
Do not want to MAKE a table, but a temporary table is fine. If it helps, I’ll paste the original SQL below.