«

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

sh wrote:
> 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

"sh" <> wrote in news:1170934298.766434.264170
@q2g2000cwa.googlegroups.com:

> 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