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_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 ROLE_ID='1'
where a.teller='0016' and b.ROLE_ID='1'
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'
where teller='0016' or ROLE_ID='1'
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