l look at the CASE WHEN...THEN.
Thanks!
-Original Message-
From: Jason Landry [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 20, 2001 12:00 PM
To: Bryan Coon; [EMAIL PROTECTED]
Subject: Re: Small select question...
You'll have to be more specific in your example -- your select
on 3/20/01 1:20 PM, Bryan Coon at [EMAIL PROTECTED] wrote:
> Sorry for the ambiguity, I was trying to make a really generic select
> statement. I just meant that if 'where a = A.a' has no matches, but 'where
> b = B.b' or 'where c = C.c' does match, the query returns what did match,
> and just r
You'll have to be more specific in your example -- your select statement
below is rather ambiguous.
However, take a look at the CASE WHEN...THEN functions that MySQL offers.
I'm sure it's exactly what you are looking for.
- Original Message -
From: "Bryan Coon" <[EMAIL PROTECTED]>
To: <
