umber 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.
>
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
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 wher