Need SQL Help
| From: | J. Kevin C. Burton | Date: | Thu, 12 Feb 2004 18:42:07 +0000 |
| Subject: | Need SQL Help | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-32920@lists.php.net to get a copy of this message | ||
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