sql语句

[梦儿-dream]

select fqa.*,
ppb.patientnum as "patientnum",ppb.realname as "realname",ppb.sex as "sex",
ppb.birthday as "birthday",ppb.ageyear as "ageyear"
from fu_question_answer fqa,fu_task ft,pd_patient_basic ppb,fu_task_shortmsg fts
where between ( fqa.taskid = ft.id and ft.patientnum = ppb.patientnum and ft.hospitalid = ppb.hospitalid )and (fqa.taskid = fts.id and fts.patientnum = ppb.patientnum and fts.hospitalid = ppb.hospitalid)
and (fqa.answer like '%67568f566dc24b45bf9f9585d4f31962%')


select fqa.*,
ppb.patientnum as "patientnum",ppb.realname as "realname",ppb.sex as "sex",
ppb.birthday as "birthday",ppb.ageyear as "ageyear"
from fu_question_answer fqa,fu_task_shortmsg fts,pd_patient_basic ppb
where fqa.taskid = fts.id and fts.patientnum = ppb.patientnum and fts.hospitalid = ppb.hospitalid
and (fqa.answer like '%67568f566dc24b45bf9f9585d4f31962%')

怎么把这两个sql语句的select查询变成只写一个sql语句的查询，求大神解答

[学海无涯-回头是岸]

中间加个union all就可以了

[jdsnhan]

select fqa.*, ppb.patientnum as "patientnum",ppb.realname as "realname",ppb.sex as "sex", ppb.birthday as "birthday",ppb.ageyear as "ageyear" from fu_question_answer fqa,fu_task ft,pd_patient_basic ppb,fu_task_shortmsg fts where between ( fqa.taskid = ft.id and ft.patientnum = ppb.patientnum and ft.hospitalid = ppb.hospitalid )and (fqa.taskid = fts.id and fts.patientnum = ppb.patientnum and fts.hospitalid = ppb.hospitalid) and (fqa.answer like '%67568f566dc24b45bf9f9585d4f31962%') 这个语句不能正确执行吧。 谁between这个区间，没有字段啊。 如果是并列条件，就一直and，如果有选择了，就用or