Nitin- If you want a SELF Join try http://www.devshed.com/Server_Side/MySQL/SQLJoins/page9.html Regards, -Martin
----- Original Message ----- From: "Nitin Nanivadekar" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, March 24, 2003 10:07 PM Subject: CONNECT BY PRIOR in MySQL > Dear Friends, > i am stuck at a great problem where a i have to find a > solution to Oracle's "CONNECT BY PRIOR" clause. > Do you have a solution using MySQL's own functions or > using VB program? > -Nitin > > __________________________________________________ > Do you Yahoo!? > Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop! > http://platinum.yahoo.com > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]