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#
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
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
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
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
5 matches
Mail list logo