t;.$fname."%'
> and IE.Rank = '$rank'
> and TD.Tenure_Status like '$tenure'
> order by FP.FirstName;
>
> -----Original Message-
> From: Jordan Morgan [mailto:[EMAIL PROTECTED]
> Sent: Sunday, September 14, 2003 4:28 PM
> To: David Sears
> S
ch
> info in the mysql docs.
>
> -Original Message-
> From: Jordan Morgan [mailto:[EMAIL PROTECTED]
> Sent: Sunday, September 14, 2003 2:45 PM
> To: David Sears
> Cc: [EMAIL PROTECTED]
> Subject: Re: Newbies asking help with LEFT JOIN
>
> I tried the parenthese
nday, September 14, 2003 12:56 PM
> To: David Sears
> Cc: [EMAIL PROTECTED]
> Subject: Re: Newbies asking help with LEFT JOIN
>
> Thanks for the prompt response David. However, it still doesn't work.
>
> The search page is here:
> http://www.jordymaeproductions.com/P
PM
> To: David Sears
> Cc: [EMAIL PROTECTED]
> Subject: Re: Newbies asking help with LEFT JOIN
>
> Thanks for the prompt response David. However, it still doesn't work.
>
> The search page is here:
> http://www.jordymaeproductions.com/PHP/latest/SearchFaculty.php4
>
> I
That's parentheses () around the inner join, not braces {}.
-Original Message-
From: Jordan Morgan [mailto:[EMAIL PROTECTED]
Sent: Sunday, September 14, 2003 12:56 PM
To: David Sears
Cc: [EMAIL PROTECTED]
Subject: Re: Newbies asking help with LEFT JOIN
Thanks for the prompt res
Thanks for the prompt response David. However, it still doesn't work.
The search page is here:
http://www.jordymaeproductions.com/PHP/latest/SearchFaculty.php4
I have a faculty from IT department named Debbie Farmer who is an instructor
with a tenure status of "Not on Tenure Track". So if I typed
I didn't have the fortitude to populate the tables with data, so I don't
know if this will work for you, but to use explicit joins try something like
the sample below. (Note that I don't like to type as much as you do:-)
select distinct IE.title, FP.LastName, FP.FirstName
from InstitutionEmploymen
