select REGISTER.FEE_SOURCEID,dictdetail.DICT_NAME from REGISTER,dictdetail
where REGISTER.FEE_SOURCEID = dictdetail.DICT_ID and DICT_TYPEID = 'FL'
union all
select CDPATIENT.SEX_ID,DICTDETAIL.DICT_NAME from CDPATIENT,DICTDETAIL where
CDPATIENT.SEX_ID=DICTDETAIL.DICT_ID and DICT_TYPEID='xb'
根据你的情况，看是用union all还是union 吧，，，
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024