Please HELP (Urgent) Sql Server 2000 query

• pepeweasel

  Newbie

  Points: 2

  More actions

  January 24, 2008 at 10:28 am

  #202709

  Hi guys!!!

  i need your help with a query. This is the problem:

  I got a view where the results are:

  Example

  id plants

  1 plant1

  1 plant2

  2 plant1

  2 plant3

  and this its ok, the problem its that the result its showing two id = 1, because it got a LEFT JOIN, but i want that my view return this:

  Example

  id plants

  1 plant1 plant2

  2 plant1 plant3

  its this posible???

  can anyone help me???

  Thanks

• toniupstny

  Hall of Fame

  Points: 3986

  More actions

  January 24, 2008 at 3:35 pm

  #771529

  Can you include your code and some sample data? I am not sure what you are trying to do.

  Toni