What is your database system?
I'm not sure subqueries will get what you're looking for. But a stored
procedure can.
create procedure GetEmails as
-- define some variables (depends on what you're doing)
declare @Email1 varchar(255), @Email2 varchar(255), @EmailMerged
varchar(255)
-- Gather data together (subqueries may not work, so get
individually)
select @Email1 = email from Table1 where blah blah blah
select @Email2 = email from Table2 where blah blah blah
-- Combine into a single value
set @EmailMerged = @Email1 + ',' + @Email2
-- Return result as a recordset
select @EmailMerged as EMailMerged
go
-----Original Message-----
From: Torrent Girl [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 31, 2005 12:37
To: SQL
Subject: Help - stumped
I am pulling 2 different email addresses from different tables through
subqueries and they both have aliases.
How can I put the two together as a list to create a seperate var?
I want subquery1_email + subquery2_email = email
TGirl
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49
Message: http://www.houseoffusion.com/lists.cfm/link=i:6:2299
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/6
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:6
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
