macromedia.dreamweaver.appdev
[Top] [All Lists]

Access SQL Question

Subject: Access SQL Question
From: "Jason Cook"
Date: Fri, 17 Aug 2007 17:33:35 -0500
Newsgroups: macromedia.dreamweaver.appdev

Say I have two fields, animal and part and each animal is listed three times 
with three parts.
Animal    Part
Bee        Wings
Bee        Eyes
Bee        Legs
Cat        Nose
Cat        Fur
Cat        Tail

I want an output like
Animal - Bee, Part 1=Wings, Part 2=Eyes, Part3=Legs
Animal - Cat, Part 1=Nose, Part2=Fur, Part3=Tail

Any suggestions?
Thanks
Jason 



<Prev in Thread] Current Thread [Next in Thread>