pls help me

Thread view:

sh - 08 Feb 2007 11:31 GMT

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

Reply to this Message

Lew - 08 Feb 2007 13:07 GMT

> hi all,
>
[quoted text clipped - 3 lines]
> please help me,
> this is related to recursive join

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

- Lew

Reply to this Message

Greg R. Broderick - 08 Feb 2007 17:37 GMT

"sh" <shailajabtech@gmail.com> 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

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...