求一条简单SQL语句

[netvsj2ee]

select SEC_LEVEL from S_TELLER_SEC where teller='0016'
select SEC_LEVEL from S_ROLE_SEC where ROLE_ID='1'

表S_TELLER_SEC字段SEC_LEVEL和teller
表S_ROLE_SEC字段SEC_LEVEL和ROLE_ID

能不能用一条SQL语句查出SEC_LEVEL的数据，谢谢大家，请帮忙~

[yyyyzzzz_2002]

SELECT SEC_LEVEL
FROM (
SELECT SEC_LEVEL FROM S_TELLER_SEC WHERE teller ='0016'
UNION ALL
SELECT SEC_LEVEL FROM S_ROLE_SEC WHERE ROLE_ID='1'
) a

--或者要求无重复数据,此句性能不好
SELECT SEC_LEVEL
FROM (
SELECT SEC_LEVEL FROM S_TELLER_SEC WHERE teller ='0016'
UNION
SELECT SEC_LEVEL FROM S_ROLE_SEC WHERE ROLE_ID='1'
) a

[hery2002]

UNION ALL

[dawugui]

[Quote=引用楼主 netvsj2ee 的帖子:]
select SEC_LEVEL from S_TELLER_SEC where teller='0016'
select SEC_LEVEL from S_ROLE_SEC where ROLE_ID='1'

表S_TELLER_SEC字段SEC_LEVEL和teller
表S_ROLE_SEC字段SEC_LEVEL和ROLE_ID

能不能用一条SQL语句查出SEC_LEVEL的数据，谢谢大家，请帮忙~
[/Quote]

select SEC_LEVEL from S_TELLER_SEC where teller='0016'
union all
select SEC_LEVEL from S_ROLE_SEC where ROLE_ID='1'

[忆轩辕]

select a.SEC_LEVEL from S_TELLER_SEC as a inner join S_ROLE_SEC as b on a.SEC_LEVEL = b.SEC_LEVEL
where a.teller='0016' and b.ROLE_ID='1'

[liangCK]

[Quote=引用 1 楼 dawugui 的回复:]
引用楼主 netvsj2ee 的帖子:
select SEC_LEVEL from S_TELLER_SEC where teller='0016'
select SEC_LEVEL from S_ROLE_SEC where ROLE_ID='1'

表S_TELLER_SEC字段SEC_LEVEL和teller
表S_ROLE_SEC字段SEC_LEVEL和ROLE_ID

能不能用一条SQL语句查出SEC_LEVEL的数据，谢谢大家，请帮忙~


select SEC_LEVEL from S_TELLER_SEC where teller='0016'
union all
select SEC_LEVEL from S_ROLE_SEC where…
[/Quote]

[xthe]

select a.SEC_LEVEL
from S_TELLER_SEC a
inner join S_ROLE_SEC b
on a.SEC_LEVEL=b.SEC_LEVEL
where a.teller='0016' and b.ROLE_ID='1'

[huangjh_love]

Select a.SEC_LEVEL From  S_TELLER_SEC a Left Outer Join S_ROLE_SEC b on a.SEC_LEVEL=b.SEC_LEVEL
where teller='0016' or  ROLE_ID='1'