Garry,
You are using mysql version 4? Unions are only supported in version 4.
If so, the only difference I can see from your example to the manual is that
each select is in brackets in the manual. Try the query:
(select cnumber from spouse where fd_status = "A")
union
(select cnumber from members where fd_status = "A");
Andy
> -Original Message-
> From: Garry Rothert [mailto:[EMAIL PROTECTED]]
> Sent: 16 January 2003 14:11
> To: [EMAIL PROTECTED]
> Subject: Need help with UNION
>
>
> Hi
> I am attempting a simple union.
>
> select cnumber from spouse where fd_status = "A"
> union
> select cnumber from members where fd_status = "A"
>
> When I run this SQL statement I get the following error.
>
> ERROR 1064 : You have are an error in your SQL syntax near 'union
> select cnumber from members where fd_status = "A"' at line 2.
>
> CNUMBER is smallint in both tables. I know this seems like a silly
> union to try but I've simplified a more complex statement to
> troubleshoot, I can't get any union to work.
> Thanks
>
> This email and any files transmitted with it are privileged,
> confidential,
> subject to
> copyright and intended solely for the use of the individual or entity to
> whom they
> are addressed. Views expressed are those of the user and not
> necessarily those
> of DPH Engineering Inc.. Any unauthorized use, copying, review or
> disclosure is
> prohibited. Please notify the sender immediately if you have received
> this
> communication in error. Thank you for your assistance and co-
> operation.
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php (the manual)
>http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php