The standard example: employee table that has the employeeid and managerid.
To get the employees reporting to a manager you need a self join.
--
Terry Dykstra
Canadian Forest Oil Ltd.
"jcd" <newsgroup-responses-1_at_waycoolgear.com> wrote in message
news:bh8cpo$10r$1_at_slb0.atl.mindspring.net...
> SQL: When would I want to join a table with itself ? Example please ?
> Thanks for any help!
>
> --
> (Only newsgroup replies will be answered. All others will be deleted.)
> http://www.WayCoolGear.com
>
>
Received on Mon Aug 11 2003 - 10:47:13 CDT
