Hi!
On Dec 02, George Georgeus wrote:
> Hi!
> I do not know how to use INSERT and UNION together.
> For example:
> INSERT INTO tmp_table_name (a)
> (SELECT a FROM table_name WHERE a=10 AND B=1 ORDER BY
> a LIMIT 10)
> UNION
> (SELECT a FROM table_name WHERE a=11 AND B=2 ORDER BY
> a LIMIT 10)
> OR
George Georgeus wrote:
> Hi!
> I do not know how to use INSERT and UNION together.
> For example:
> INSERT INTO tmp_table_name (a)
> (SELECT a FROM table_name WHERE a=10 AND B=1 ORDER BY a LIMIT
> 10) UNION (SELECT a FROM table_name WHERE a=11 AND B=2 ORDER
> BY a LIMIT 10) ORDER BY a; It does not
Hi!
I do not know how to use INSERT and UNION together.
For example:
INSERT INTO tmp_table_name (a)
(SELECT a FROM table_name WHERE a=10 AND B=1 ORDER BY
a LIMIT 10)
UNION
(SELECT a FROM table_name WHERE a=11 AND B=2 ORDER BY
a LIMIT 10)
ORDER BY a;
It does not work. But I think it should. Have the
On Tue, 12 Nov 2002 12:02:04 +0100
[EMAIL PROTECTED] wrote:
>
> Your message cannot be posted because it appears to be either spam or
> simply off topic to our filter. To bypass the filter you must include
> one of the following words in your message:
>
> sql,query
>
> If you just reply to this
Hallo my friends
I am writing a database application program with PHP
and MySQL. I have two tables that I want to query in
the same time with "SELECT...UNION SELECT ..." syntax.
Too many errors encountered; the rest of the message
is ignored:
The 2 tables are APPOINTMENT table
