how to output multiple receds from one record in a query

  • Thread starter Thread starter mg
  • Start date Start date
M

mg

ok, last one.

in a query, i want to SELECT records, and output multiple records for each
one in the source table.
example:
source record fields = <company1, blue, red, yellow>
i want to output:
company1,blue
company1,red
company1,yellow

reason: i need a report to show companies GROUPED by the colors: (and each
company can have multiple colors)
blue:
company1
company7
company44
red:
company1
company2
company55
 
SELECT Field1, Field2
FROM MyTable
UNION
SELECT Field1, Field3
FROM MyTable
UNION
SELECT Field1, Field4
FROM MyTable
 
Back
Top