H all, newbie here again.

Is it possible to do two SELECTS in the same SQL call, and return the
results of both in the same result set?
(This two selects would be getting the same columns from the same
table).

Many thanks,
Lister

On Sep 17, 4:37 pm, lister <listerofsme...@hotmail.com> wrote:
> H all, newbie here again.
>
> Is it possible to do two SELECTS in the same SQL call, and return the
> results of both in the same result set?
> (This two selects would be getting the same columns from the same
> table).
>
> Many thanks,
> Lister

<http://dev.mysql.com/doc/refman/5.0/en/union.html>

On Sep 17, 9:39 pm, ZeldorBlat <zeldorb...@gmail.com> wrote:
> <http://dev.mysql.com/doc/refman/5.0/en/union.html>

You're a star! Thanks a million. :-)

On Sep 17, 4:48 pm, lister <listerofsme...@hotmail.com> wrote:
> On Sep 17, 9:39 pm, ZeldorBlat <zeldorb...@gmail.com> wrote:
>
> > <http://dev.mysql.com/doc/refman/5.0/en/union.html>
>
> You're a star! Thanks a million. :-)

Not really. All I did was read the manual.

ZeldorBlat wrote:
> On Sep 17, 4:48 pm, lister <listerofsme...@hotmail.com> wrote:
>> On Sep 17, 9:39 pm, ZeldorBlat <zeldorb...@gmail.com> wrote:
>>
>>> <http://dev.mysql.com/doc/refman/5.0/en/union.html>
>>
>> You're a star! Thanks a million. :-)
>
> Not really. All I did was read the manual.

About 70% of the questions that I answer on this form I do so simply by
reading the manual.

Posters could save a lot of time by doing similar.

On Tue, 18 Sep 2007 10:34:54 +0100, "Paul Lautman"
<paul.lautman@btinternet.com> wrote:

>About 70% of the questions that I answer on this form I do so simply by
>reading the manual.
>
>Posters could save a lot of time by doing similar.

Not when you don't know where to look.

I have read a lot of parts of the manual, and still can ask silly
questions here from time to time, because I missed something. It takes
30 seconds to somebody who knows, while it can take me more than one
hour to go to the very deep footnotes completely missing the headline,
because I thing I already read it.

And worse in that case : OP did not know that the correct word to look
for was union, he thought it was concatenate ; browsing the manual
would have been for this a waste of time. Now he knows where to read,
that's very valuable information that the manual can not give him
without a thorough review of it, which would take hours.

On Sep 18, 10:34 am, "Paul Lautman" <paul.laut...@btinternet.com>
wrote:
> ZeldorBlat wrote:
> > On Sep 17, 4:48 pm, lister <listerofsme...@hotmail.com> wrote:
> >> On Sep 17, 9:39 pm, ZeldorBlat <zeldorb...@gmail.com> wrote:
>
> >>> <http://dev.mysql.com/doc/refman/5.0/en/union.html>
>
> >> You're a star! Thanks a million. :-)
>
> > Not really. All I did was read the manual.
>
> About 70% of the questions that I answer on this form I do so simply by
> reading the manual.
>
> Posters could save a lot of time by doing similar.

I appreciate it must be frustrating for you, but finding anything in
the online mysql manual seems extremely difficult IMHO. Even when I
know the keyword it seems difficult to find the manual page for it.

On Wed, 19 Sep 2007 00:56:26 -0700, lister
<listerofsmeg01@hotmail.com> wrote:

>I appreciate it must be frustrating for you, but finding anything in
>the online mysql manual seems extremely difficult IMHO. Even when I
>know the keyword it seems difficult to find the manual page for it.

I downloaded a CHM version. It's findable on any P2P thing. Search for
MySQL CHM. If you are under linux, there are some chm viewers (I use
gnochm, because of gnome, but you can find a few others).
It lets you make searches in the whole document easily, and you always
have it offline.
It's *very* valuable.