RE: Need help with UNION

2003-01-16 Thread Andy Eastham
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. >

RE: Need help with UNION

2003-01-16 Thread Victor Pendleton
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

Need help with UNION

2003-01-16 Thread Garry Rothert
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