原帖由 "rock_jq" 发表:
1.select animal.name,food.name form animal , food
where animal.animal_id=food.animal_id
and food.animal_id in ( select animal_id form food group by animal_id having count(*)=1);
2.select animal...........
欢迎光临 Chinaunix (http://bbs.chinaunix.net/) | Powered by Discuz! X3.2 |