Recursive query

[jarjisjaffer]

Hi guys,
I've specified my task below.

There is a table called Centre which has 2 fields called CentreNr and RelatedCentreNr .

If i give parameter CentreNr, then it should retieve corresponding record as well as the relatedcentres till there is no related centre. For example consider the following scenario..

If the parameter(Centr eNr) is 'A001'

CentreNr | RelatedCentreNr
--------------------------------------------------
A001 | B001
B001 | C001
C001 | D001
D001 | NULL

Can anyone help me in this task?
Thanx in advance.....

[Saii]

Can you please paste your code also.

[jarjisjaffer]

Thanx for the reply..
i dont have any code here. I just want to create a query which is retrieving data which i have specified in my previous post...

[debasisdas]

please post your table structure with the field relations if any.