|
RE: Another SQL Question
Do you only want to include one more level (easy), or did you just use that for illustration and really want to recursively follow the parent-child relationship chain and get all child records there are, arbitrary number of levels deep (hard)?
Also, I am uncertain why you are using LIKE instead of =, if your data resembles the example. Is there any reason for that?
| 
