otherguy (Cameron Wilhelm ) wrote:
Well, keep in mind that although SQL can do a lot in a single
statement, it can't always do *everything* required for a business
function in one statement.
As I'm painfully aware of, but was hopeful about.
Your hopes were sensible -- I believe that some SQL v
On Saturday, June 28, 2003, at 07:15 PM, Bruce Feist wrote:
otherguy wrote:
On Saturday, June 28, 2003, at 03:43 PM, MyLists wrote:
That gets me halfway there
BF: Does it?
No, I don't think it does, upon further consideration and testing...
I thought it did b/c I read, and misinterprete
otherguy wrote:
On Saturday, June 28, 2003, at 03:43 PM, MyLists wrote:
That gets me halfway there
BF: Does it?
No, I don't think it does, upon further consideration and testing...
I thought it did b/c I read, and misinterpreted the UNION
documentation
BF: In your original question
On Saturday, June 28, 2003, at 03:43 PM, MyLists wrote:
otherguy wrote:
That gets me halfway there
Does it?
Yes, it does.
No, I don't think it does, upon further consideration and testing... I
thought it did b/c I read, and misinterpreted the UNION
documentation
In your original questio
- Original Message -
From: "Bruce Feist" <[EMAIL PROTECTED]>
To: "MySQL List" <[EMAIL PROTECTED]>
Sent: Saturday, June 28, 2003 6:28 PM
Subject: Re: Advanced Query Help (My brain hurts!)
> otherguy wrote:
>
> > That gets me halfway there
&g
PROTECTED]>
Sent: Saturday, June 28, 2003 6:17 PM
Subject: Re: Advanced Query Help (My brain hurts!)
> Thank you!
>
> That gets me halfway there, and not to my surprise, it's not even that
> hard! I should've known that it wouldn't be.
>
> So the other par
otherguy wrote:
That gets me halfway there
Does it? In your original question, you'd indicated that you only
wanted zips where *both* criteria were met -- enough CIRGs and enough
CILTs. By using a UNION, you'll be getting zips where *either* is met.
Bruce Feist
--
MySQL General Mailing Li
Thank you!
That gets me halfway there, and not to my surprise, it's not even that
hard! I should've known that it wouldn't be.
So the other part that I truly have no idea how to do the following:
UPDATE this_other_table
SET satus =
WHERE zipcode IN ();
can someone provide me with some poi
ED]>; "MySQL List" <[EMAIL PROTECTED]>;
"otherguy" <[EMAIL PROTECTED]>
Cc: "Terry Vanstory" <[EMAIL PROTECTED]>
Sent: Saturday, June 28, 2003 12:05 AM
Subject: RE: Advanced Query Help (My brain hurts!)
> would u have an example of how to use uni
Subject: Re: Advanced Query Help (My brain hurts!)
How about a UNION statement? If the two queries are independently returning
what you need, then you can just "append" the two results by using UNION.
Good Luck!
Dennis
- Original Message -
From: "otherguy" <[EMAIL
How about a UNION statement? If the two queries are independently returning
what you need, then you can just "append" the two results by using UNION.
Good Luck!
Dennis
- Original Message -
From: "otherguy" <[EMAIL PROTECTED]>
To: "MySQL List" <[EMAIL PROTECTED]>
Cc: "Terry Vanstory" <[EM
11 matches
Mail list logo