<div>
select user_email from users<br />
UNION<br />
select email from mail_list<br />
order by 1
</div>


select user_email from users
UNION
select email from mail_list
order by 1

<div>
thanks for your quick reply<br />
<br />
It works, <br />
<br />
could you please explain order by 1? <br />
<br />

</div>


thanks for your quick reply

It works,

could you please explain order by 1?



<div>
<div class="content wysiwyg-content">
Hi All, <br />
<br />
I have to tables<br />
<br />
users table &nbsp;-- user_email(field)<br />
aaa@aa.com<br />
bbb@cc.com<br />
ccc@cc.com<br />
test@test.com<br />
<br />
mail_list table -- email(field)<br />
aaa@aa.com<br />
ddd@fff.com<br />
sss@qq.com<br />
test@test.com<br />
<br />
output should be like this (distinct_email) ordered<br />
aaa@aa.com<br />
bbb@cc.com<br />
ccc@cc.com<br />
ddd@fff.com<br />
sss@qq.com<br />
test@test.com<br />
<br />
I want to join two tables, and select disctinc email adres<br />
<br />
thanks in advance<br />
Nurbek<br />
<br />

</div>
</div>


Hi All, 

I have to tables

users table  -- user_email(field)
aaa@aa.com
bbb@cc.com
ccc@cc.com
test@test.com

mail_list table -- email(field)
aaa@aa.com
ddd@fff.com
sss@qq.com
test@test.com

output should be like this (distinct_email) ordered
aaa@aa.com
bbb@cc.com
ccc@cc.com
ddd@fff.com
sss@qq.com
test@test.com

I want to join two tables, and select disctinc email adres

thanks in advance
Nurbek



Join two tables and select distinct

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.