(select) inner join (select) - SQL Server Forums

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.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

(select) inner join (select)

Author

Topic

neutcomp
Posting Yak Master

111 Posts

Posted - 2002-11-27 : 04:53:07

Hello,

I have 2 query's with results:
query one: 43,95
query two: 41,42,43,44

now I want as result:
41,42,43,44,95

How can I astablish that?
Here are my two query's
1)
select tbl_mfs_link_directory_permission.permission_ID
from tbl_mfs_link_directory_user INNER JOIN tbl_mfs_link_directory_permission
on (tbl_mfs_link_directory_user.directory_ID = tbl_mfs_link_directory_permission.group_ID)
where tbl_mfs_link_directory_user.user_ID = '73'

2)
select tbl_user_link_user_permission.permission_ID
from tbl_user_link_user_permission
where tbl_user_link_user_permission.has_permission = '1'
and tbl_user_link_user_permission.user_ID = '73'

Thanxx

Cya
Bjorn

colinm
Yak Posting Veteran

62 Posts

Posted - 2002-11-27 : 06:05:34

Try this:


select tbl_mfs_link_directory_permission.permission_ID 
from tbl_mfs_link_directory_user INNER JOIN tbl_mfs_link_directory_permission 
on (tbl_mfs_link_directory_user.directory_ID = tbl_mfs_link_directory_permission.group_ID) 
where tbl_mfs_link_directory_user.user_ID = '73' 
union all
select tbl_user_link_user_permission.permission_ID 
from tbl_user_link_user_permission 
where tbl_user_link_user_permission.has_permission = '1' 
and tbl_user_link_user_permission.user_ID = '73' 
order by tbl_mfs_link_directory_permission.permission_ID

mr_mist
Grunnio

1870 Posts

Posted - 2002-11-27 : 06:10:03

I think you would need UNION to get the result set as specified, not UNION ALL.

-------
Moo.

colinm
Yak Posting Veteran

62 Posts

Posted - 2002-11-27 : 07:02:51

yep, dump the all clause. I always get them mixed up

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources