This is either quite simple or quite difficult, but I'm at a loss to figure out which!
I have a simple table with 4 fields. A simple example with sample data:
FIELD1,FIELD2, FIELD3, FIELD4
Brazil, Dog, Fido, 12 years
Brazil, Cat, Boots, 3 years
Brazil, Cat, Socks, 5 years
Canada, Cat, Boots, 9 years
France, Dog, Spot, 3 years
I want a query that will output all records but be displayed as follows:
Brazil Dog Fido 12 years
Cat Boots 3 years
Cat Socks 5 years
Canada Cat Boots 9 years
France Dog Spot 3 years
This is very easy to do in QMF by using the BREAK command when displaying the results, but I can't find a simple way to do it. GROUP BY seems like the most likely candidate but that "aggregate function" message is giving me grief.
Thanks!
I have a simple table with 4 fields. A simple example with sample data:
FIELD1,FIELD2, FIELD3, FIELD4
Brazil, Dog, Fido, 12 years
Brazil, Cat, Boots, 3 years
Brazil, Cat, Socks, 5 years
Canada, Cat, Boots, 9 years
France, Dog, Spot, 3 years
I want a query that will output all records but be displayed as follows:
Brazil Dog Fido 12 years
Cat Boots 3 years
Cat Socks 5 years
Canada Cat Boots 9 years
France Dog Spot 3 years
This is very easy to do in QMF by using the BREAK command when displaying the results, but I can't find a simple way to do it. GROUP BY seems like the most likely candidate but that "aggregate function" message is giving me grief.
Thanks!
