- 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
>
> Does it?
Yes, it does.
>In your original que
query the UNION
result set - but for the purposes of MySQL, you're going to have to JOIN on
a TEMP table.
Good Luck!
Dennis
- Original Message -
From: "otherguy" <[EMAIL PROTECTED]>
To: "MyLists" <[EMAIL PROTECTED]>
Cc: "MySQL List" <[EMAIL
ntation on UNION - it's not that
difficult :-). Basically it's something like
SELECT A, B, C
FROM FOO
UNION
SELECT X, Y, Z
FROM FOO
Good Luck!
Dennis
- Original Message -
From: "electroteque" <[EMAIL PROTECTED]>
To: "MyLists" <[EMAIL PROTECT
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
Interesting question. I'm not sure if such a tool exists, so I will explain
how I would go about it without the aid of a third-party tool.
The main thing you should realize right off the bat is that Access gives you
a lot of functionality with buttons and other controls and they are quite
easy to