Dan,
Wednesday, May 22, 2002, 6:57:49 PM, you wrote:
DL> Could anybody tell me why the following query does not work?
DL> SELECT location FROM visiExPr where location=1 union (SELECT location FROM
> visiExPr where location=0);
DL> Thanks!
What exactly doesn't work? Have you got an error or wrong result?
Note: if location has the same value in both SELECTs there will be
displayed only one row.
DL> Dan
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Victoria Reznichenko
/ /|_/ / // /\ \/ /_/ / /__ Victoria.Reznichenko@stripped
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
