Self Join??

• msutter

  SSC Eights!

  Points: 990

  More actions

  January 23, 2004 at 3:26 pm

  #108845

  I have a table that contains

  ID, DESC, PARENT_ID

  I need to end up with

  ID-DESC, PARENT_ID-DESC

  I know how to do ID_DESC with

  select LTRIM(ltrim(Accounts_ID) + '-' + ltrim(Accounts_Description)) as ID

  I don't know how to look up the description to do the parentID-Desc.

  Any help will be appreciated.

   

• gljjr

  SSChampion

  Points: 10080

  More actions

  January 23, 2004 at 3:35 pm

  #491476

  You might want to look at the following thread... http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=96968

   

  
  
  
  Gary Johnson
  Microsoft Natural Language Group
  DBA, Sr. DB Engineer

  This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.

• Jonathan

  SSC-Insane

  Points: 20427

  More actions

  January 23, 2004 at 3:55 pm

  #491481

  Yes, you do need a self-join.  Something like this:

  SELECT LTRIM(a.ID) + '-' + a.Descr AS ID_Desc, LTRIM(b.ID) + '-' + b.Descr AS Parent_Desc

  FROM YourTableName a JOIN YourTableName b on b.ID = a.Parent_ID

  
  
  --Jonathan

• msutter

  SSC Eights!

  Points: 990

  More actions

  January 25, 2004 at 12:01 pm

  #491536

  Thanks to all for the replys.  I've got it.

   

  -Malcolm