MySQL Multiple tables / results

[RG]

Hopefully someone here can help.
I would like to perform multiple queries to a MySQL database and have all
the results in 1 result set.
Is this possible?

TIA
RG

[Alex Farran]

RG writes:

Hopefully someone here can help.
I would like to perform multiple queries to a MySQL database and have all
the results in 1 result set.
Is this possible?

How do you mean? You could do this for example:

select * from table where (<query 1>) or (<query 2>);

Which would return the union of the results of the two queries.
--

__o Alex Farran
_`\<,_ Analyst / Programmer
(_)/ (_) www.alexfarran.com

[Andy Hassall]

On Sat, 13 Sep 2003 11:34:16 +0100, "RG" <[e-mail]> wrote:

Hopefully someone here can help.
I would like to perform multiple queries to a MySQL database and have all
the results in 1 result set.
Is this possible?

Not unless you give more details. In general, no; how do you delimit the
multiple result sets? What if each query returns a different number and type of
columns? It becomes nonsensical very quickly.

--
Andy Hassall (an**@andyh.co.uk) icq(5747695) (http://www.andyh.co.uk)
Space: disk usage analysis tool (http://www.andyhsoftware.co.uk/space)

[Kurt Milligan]

Do the tables have common connections, so that you can do a JOIN?
(are they related in some way?)

http://www.mysql.com/doc/en/JOIN.html

You need to be more specifc and tell us your table structures
and what you want out of the query if you'd like more help.

-Kurt
http://www.quanetic.com
RG wrote:

Hopefully someone here can help.
I would like to perform multiple queries to a MySQL database and have all
the results in 1 result set.
Is this possible?

TIA
RG