Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
harshal_in
Aged Yak Warrior
633 Posts |
 Posted - 2003-07-21 : 06:04:44
|
| hi,I have a table A1 (Email varchar(100))and second Table B1 (Email Varchar(100))A1tom@abc.comfdsa@csa.comB1harshal@hotmail.comsachin@hotmail.comI need a query which will return the email ids in a single result set like:Emailtom@abc.comfdsa@csa.comharshal@hotmail.comsachin@hotmail.comIs this possible?please help.Regards, harshalThe Judgement of the Judge is as good as the Judge. |
|
|
harshal_in
Aged Yak Warrior
633 Posts |
Posted - 2003-07-21 : 06:08:17
|
| ok ,I got it by using union.The Judgement of the Judge is as good as the Judge. |
 |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-07-21 : 10:37:40
|
| Wow 4 minutes...pretty good self help..but just for the others...SELECT Email FROM A1 UNION SELECT Email FROM B1Any Predicates?Brett8-) |
|
|
|
|
|
|
simple query