Hello Guys/Gals. I've been looking around forever for some help, never
thought about asking the ListServ.
Here it goes:
I have a SQL statement that looks like this:
"SELECT EMPLOYEENAME,SUPERVISORID WHERE EMPLOYEEID='$employeeid'"
what I want to do is lookup the supervisor's name in the same SQL
statement. If not, I would have to use an function, and if I have a 100
employee's in the list, that takes an enormous amount of time if I have
to load that function every row.
Is there a way to do it all in the same 1 SQL statement?
Help Please?
Kevin
