Database

;with cte as
(
	select t1.parentid,t1.id,0 AS [Level] from  @tbl t1	
	where t1.parentid  = 'FG'	
	union all 	
	select t1.parentid,t1.id,[Level]+1 from  @tbl t1
	inner join cte c
	on c.id = t1.parentid
)
select left(Decendants,len(Decendants)-1) Decandants
from
    (
		select id  + ','
		from cte
		for xml path ('')
    ) Result(Decendants)

Decandants
G1,GP01,GP0101,G11,G12,G111,G112,G113

Niladri_Biswas wrote:

Note- I sql server 2008, for solving this kind of problem you can take the advantage of Hierarchial Id's

SELECT A.SNO, A.CODE, A.QTY, A.RATE, B.NAME
FROM DETAIL A
	INNER JOIN MASTER B ON A.CODE=B.CODE

M Riaz Bashir wrote:

Kindly let me know how may I convert following Oracle sql into MS-Access ?

SELECT A.SNO, A.CODE, A.QTY, A.RATE, B.NAME
FROM DETAIL A RIGHT JOIN MASTER B
WHERE A.CODE=B.CODE

a.code = b.code(+)

a.code(+) = b.code

a.code = b.code(+)