Help needed with sql query!

[tetorvik]

Hi!
I’m having a problem with a SQL query. I have two database tables Customer and CustomerClassification.

Customer table contains information like name, address, phone etc.

CustomerClassification contains other information about the customer like hobbies and other interests. One Customer may have several rows in CustomerClassification!

I would like to select customer information with his/her classification(s) within a single query and i would like to receive only one row for each customer. The last column (Classification) should contain all the classifications for the customer.

The result should look like:


CustomerName Address Phone Classification

Row1: Abrahamson, Arne Street1 13456 Baseball
Golf Pizza

Row2: Abrahamson, Berit Street1 12456 Comedies
Meet balls


Is this possible? Any ideas?
Thanks in advance!

 

[tetorvik]

Correction:

Baseball, golf and pizza are row1 classifications and Comedies and meet balls are row2 classification.

 

[tlbroadbent]

My reply in thread220-155580 should give you an idea how to create a cross-tab query in SQL. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.