select p.person_code,s1.sex_name,s2.sex_name
from person p,sex_dict s1,sex_dict s2
where p.person_sex1 = s1.sex_code
and p.person_sex2 = s2.sex_code
from person p,sex_dict s1,sex_dict s2
where p.person_sex1 = s1.sex_code
and p.person_sex2 = s2.sex_code
from person , sex_dict a, sex_dict b
where person_sex1=a.sex_code and person_sex2=b.sex_code;
from person,sex_dict
where person_sex1=sex_dict.sex_code and person_sex2=sex_dict.sex_code
Impylm(韩冰) 好好学习吧。谢谢大家。揭帖