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
fully duplicate port
this query to mysql, and would appreciate any thoughts or insights on how to
do this.
Thanks!
-Original Message-
From: Geoff Coffey [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 20, 2001 12:52 PM
To: Bryan Coon; 'Jason Landry'; [EMAIL PROTECTED]
Subject:
t; <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, March 20, 2001 1:30 PM
Subject: Small select question...
> Hopefully this is not too lame a question...
>
> In oracle, I can do this:
>
> select a, b, c from A, B, C where a = A.a (+) and b = B.b (+) an
Hopefully this is not too lame a question...
In oracle, I can do this:
select a, b, c from A, B, C where a = A.a (+) and b = B.b (+) and c = C.c;
What is the equivalent in MySQL? The (+) allows that 'where' statement to
be kind of optional (I think). Basically I want to do a select on multiple
