Need help with a sql query 1

[Amapuche]

Hello,

I need help with a query that I cant get to work or rather
dont know where to start anymore.

I have a data that looks somthing like this if I do a
simple select statement eg. SELECT animal, colour FROM tbl_animals

Animal Colour
------ ------
Cat Brown
Cat Red
Cat Orange
Cat Black
Cat White
Dog Black
Dog Red
Dog Orange
Dog White

but what I want the data to look like is this when I do a
query to output to a report. (crystal reports 8.5)

Animal Colours
------ --------------------------------
Cat Brown Red Orange Black White
Dog Black Red Orange White

Is this possible? and if so, how would I go about doing
this.

Thanks for listening

Mapuche

 

[tlbroadbent]

I've answered a similar question three times this week. Check the following resources for code that should help.

http://www.sqlteam.com/item.asp?ItemID=2955

http://www.sqlmag.com/articles/index.cfm?articleid=15608

http://www.fawcette.com/vsm/2002_04/online/online_eprods/c_rjennings_4_29/

http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=322&lngWId=5

Script page a SWYNK.com:

http://www.swynk.com/sqlscripts/misc7-2.asp

Specific scripts you can download from SWYNK:

http://www.swynk.com/downloads/sp_Query_Pivot.sql

http://www.swynk.com/downloads/sp_cross.sql

Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.