Hi all,
Can someone tell me how to do this using IBObjects,
I have tried eleventy different (JOINS, LINKS, etc)
ways and want to have it in one SQL but have had no
luck: table PEOPLE: PIN INTEGER KEY, LASTNAME VARCHAR,
SUPERV INTEGER,
This is a self refering table by way of the SUPERV
field.
PIN has a supervisor which pin is in SUPERV, who
is also in the table Example:
1, John, 3
3, Robert, 0
4, Ralph, 3
Robert is a supervisor for John and Ralph....

Thanks,
Steve Fields