我有两个表。疾病-----------------------------|ID|NAME|-----------------------------|1|Disease1||2|Disease2||3|Disease3|疾病_症状-----------------------------|DISEASE_ID|SYMPTOM_ID|-----------------------------|1|1||1|2||1|3||1|4||2|1||2|2|我想选择所有具有症状1或2和3或4的疾病。我试过:SELECT*FROMdiseases_symtomsWHERE(symptoms='1