Replace on Join

2007-10-29 Thread Kevin Murphy
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

Re: Counting Distinct values - with a twist SOLVED

2002-04-16 Thread Kevin Murphy
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

Counting Distinct values - with a twist

2002-04-16 Thread Kevin Murphy
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