More on.. Concatenate Fields from Related Tables

[AshleyRickards]

As you stated if there are multiple Items I would need to list those also. Here's more detail. Thanks.

ORDERS
ID Customer
1 Company A
2 Company B
3 Company C



ITEMS
ID OID Desc
1 1 Item 1
2 1 Item 2
3 1 Item 3


SELECT ORDERS AND ALL ITS ITEMS


RESULTS:

1, "Company A", "Item 1, Item 2, Item 3"


Concatinate all rows of a sub table.

Ashley L Rickards
SQL DBA


Ashley L Rickards
SQL DBA

 

[knowZnuff2breakit]

Ashley,

There is some code and instructions in 'faq 701-4233'. I was looking for the same thing.

In case anyone else sees this: is there a way to make this code join mulitiple fields? I'm getting duplicate returns because I can't narrow it down...

 

[dreameR25]

Read more about CROSS TAB queries.

 

[AshleyRickards]

Thanks .. knowsZnuff2breakit and crespo. I'll check it out.

Ashley L Rickards
SQL DBA