pls help me

Discussion in 'Java' started by sh, Feb 8, 2007.

  1. sh

    sh Guest

    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, Feb 8, 2007
    #1
    1. Advertising

  2. sh

    Lew Guest

    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
    Lew, Feb 8, 2007
    #2
    1. Advertising

  3. "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
    Greg R. Broderick, Feb 8, 2007
    #3
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Alistair Lamb

    CLOCK__SIGNAL constraint! pls help

    Alistair Lamb, Mar 24, 2005, in forum: VHDL
    Replies:
    1
    Views:
    1,538
    Tim Good
    Mar 24, 2005
  2. James Bond
    Replies:
    0
    Views:
    516
    James Bond
    Aug 3, 2004
  3. Rahul S.
    Replies:
    3
    Views:
    596
    Flash Gordon
    Nov 1, 2004
  4. Replies:
    1
    Views:
    274
    RedGrittyBrick
    Jan 2, 2008
  5. Emiliano
    Replies:
    2
    Views:
    314
    Rajesh.V
    Oct 16, 2003
Loading...

Share This Page