Re: CONNECT BY PRIOR in MySQL

2003-03-24 Thread Martin Gainty
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 P

CONNECT BY PRIOR in MySQL

2003-03-24 Thread Nitin Nanivadekar
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 Ma