What version of MySQL are you using? UNION is implemented in MySQL 4.0.0.
Check out http://www.mysql.com/doc/en/UNION.html
for more information.
Victor Pendleton
-Original Message-
From: Garry Rothert [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 16, 2003 8:11 AM
To: [EMAIL
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