PULLING DATA AND DATA ASSOCIATED WITH RECORD

[ss7415]

i have never come across this , i would appriciate some assistance.

I am using crystal xi and oracel 9i

i have two main fields wo_nbr and a lot_nbr (i am only looking at lot_nbr with a 'W' as the first character).
wo_nbr will be a parameter.

when i return my records with that wo_nbr, i want it to look at the lot_nbr and grab the data associated to those lot_nbr and those accosicated with those , until it captures all the data.

so the data will start at a level and i want to get all the data associated below that level.

if i need to explain more plese let me know.

 

[ss7415]

im sorry i used caps, i didnt relize that

 

[ss7415]

if i take the W off the lot_nbr, it becomes a Wo_nbr.

 

[ss7415]

any help would be appricated, i guess this is a hierarchies. i never gone thru this before.

once again sorry for the caps, it was intentional

 

[philhege]

I am using crystal xi and oracel 9i

It would probably help you to post in those fora. This is Microsoft SQL Server.