pls help me

[sh]

hi all,

i posted one oracle query but i want to convert same query in to
mysql.

please help me,
this is related to recursive join



WITH TReferal(referal_id) as(select referal_id from TReferalApplied
where referal_id=19 UNION ALL select ra.id from TReferalApplied ra
JOIN TReferal r ON r.referal_id=ra.referal_id) select count(*) from
TReferal; -

thanks in advance

 

[Lew]

hi all,

i posted one oracle query but i want to convert same query in to
mysql.

please help me,
this is related to recursive join

but not to Java. Try comp.databases or similar.

- Lew

 

[Greg R. Broderick]

hi all,

i posted one oracle query but i want to convert same query in to
mysql.

Try comp.databases.mysql for help with SQL. This news group is for Java.

Cheers
GRB