Distinct Row with Multi Values?

• Michelle-164472

  SSCommitted

  Points: 1715

  More actions

  November 12, 2004 at 1:24 pm

  #165444

  Hi All,

  I have a query where I need to ONE row for each say Prod_Id...however there are multiple Assignees with the same Prod_Id...is there a way to produce a result set like this:

  1, (jackie, luke, alice), 34, tester, 68, GO

  Prod_id, Assignees, ALL other columns are the same...

  1, Jackie, 34, tester, 68, GO

  1, Luke, 34, tester, 68, GO

  1, Alice, 34, tester, 68, GO

  I've tried Distinct, Having and so on...still getting the multiple rows...I am joining tables to acquire the "Assignees" name...

  Thanks...

• Michelle-164472

  SSCommitted

  Points: 1715

  More actions

  November 12, 2004 at 1:39 pm

  #530009

  Sorry, I posted to the WRONG forum...