SQL UNION Trouble

2003-12-09 Thread Mark Leder
In the following query I want the email addresses from two different tables to be grouped together (for sending in CFMail), can't get it to work, what am I missing? (BTW: the individual queries work just not as a UNION) cfquery name=qMailMessage datasource=#REQUEST.dsnSQL#

Re: SQL UNION Trouble

2003-12-09 Thread Nick de Voil
Mark In the following query I want the email addresses from two different tables to be grouped together (for sending in CFMail), can't get it to work, what am I missing? (BTW: the individual queries work just not as a UNION) Try putting the column names in the same order in both parts of the

RE: SQL UNION Trouble

2003-12-09 Thread Adrian Lynch
AS 'col3', col5 FROM table2 That's a rough guess though, it's been a while since I've done this. Ade -Original Message- From: Mark Leder [mailto:[EMAIL PROTECTED] Sent: 09 December 2003 16:40 To: CF-Talk Subject: SQL UNION Trouble In the following query I want the email addresses from

RE: SQL UNION Trouble

2003-12-09 Thread Mark Leder
Your both right, thanks. Thanks, Mark -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 11:55 AM To: CF-Talk Subject: RE: SQL UNION Trouble Try aliasing your columns. I think you need to have the same column names and number of columns

Re: SQL UNION Trouble

2003-12-09 Thread Sam Farmer
What error message are you getting? Also your column order is different in the two queries which will cause problems.Make them the same order (email, firstname, lastname) and see if that works. Sam [EMAIL PROTECTED] 12/09/03 11:39AM In the following query I want the email addresses from two