iated version of the query that is trying
to match them, and it doesn't work. Any suggestions?
SELECT * FROM schedule
LEFT JOIN directory ON
( REPLACE('@wncc.edu','@wnc.edu',schedule.email) = directory.email
)
--
Kevin Murphy
Webmaster: Information and Mar
trying to make it come out pretty. My public thanks
to Gurhan for the simple solution.
-Kevin
on 4/16/02 3:46 PM, Kevin Murphy at [EMAIL PROTECTED] wrote:
> Hello.
>
> I have just spent the afternoon pouring over the mailing list archives and
> the manual trying to find a way to
than one
expression, or, for that matter, what to give it for expressions in the
first place! I've tried trial-and-error, and nothing seemed to be yielding
predictable results.
So, I'm off to write a PHP script to generate this silly report. But if
someone comes up with a way to do it