Re: [PHP-DB] Need SQL Help

2004-02-12 Thread John W. Holmes
From: "J. Kevin C. Burton" <[EMAIL PROTECTED]> > 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 hav

[PHP-DB] Need SQL Help

2004-02-12 Thread J. Kevin C. Burton
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