View Single Post
  #1 (permalink)  
Old February 20th, 2007, 07:05 AM
s2mo s2mo is offline
Registered User
 
Join Date: Feb 2007
Location: , , .
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default parent child connect

Hi, I am trying to view a 'structured' bill of materials which has two fields, bomparent and bomchild - and i want to report down the tree from any given bomparent. I've done this before with oracle sql, but in sql server I don't think there is a "start with" equivalent when using connect.

Can anyone offer an alternative?
Many thanks in advance.

Reply With Quote