Dear,
I have an table which like to use recursive join but I wonder how to use
it. Please see the table struc below.
emp.id,emp name, emp salary, emp head-id
001,mr. a,10000,001
002,mr. b,5000,001
003,mr. c,5000,003
004,mr. d,5000,003
Where emp. head-id is id from emp.id. If I'd like to know which head
count name of id 002 (it must shown name from id 001). How could I do with
mysql?
Regards,
Sommai Fongnamthip
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php