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 fro
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
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
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 th
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)
username="#REQUEST.dsnUID#" password="#REQUEST.dsnPWD#">
SELECT L.email, L.
5 matches
Mail list logo