S
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
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