sql一对多 多行匹配

发布网友

我来回答

共1个回答

热心网友

select * from fileKeywords a
left join file b on a.docid=b.record_number
where (a.dataid=1037 and a.value='atb') or (a.dataid=1038 and a.value=11) or (a.dataid=1039 and a.value='4.57')

热心网友

select * from fileKeywords a
left join file b on a.docid=b.record_number
where (a.dataid=1037 and a.value='atb') or (a.dataid=1038 and a.value=11) or (a.dataid=1039 and a.value='4.57')

热心网友

select * from fileKeywords a
left join file b on a.docid=b.record_number
where (a.dataid=1037 and a.value='atb') or (a.dataid=1038 and a.value=11) or (a.dataid=1039 and a.value='4.57')

热心网友

select * from fileKeywords a
left join file b on a.docid=b.record_number
where (a.dataid=1037 and a.value='atb') or (a.dataid=1038 and a.value=11) or (a.dataid=1039 and a.value='4.57')

热心网友

select * from fileKeywords a
left join file b on a.docid=b.record_number
where (a.dataid=1037 and a.value='atb') or (a.dataid=1038 and a.value=11) or (a.dataid=1039 and a.value='4.57')

热心网友

select * from fileKeywords a
left join file b on a.docid=b.record_number
where (a.dataid=1037 and a.value='atb') or (a.dataid=1038 and a.value=11) or (a.dataid=1039 and a.value='4.57')

热心网友

select * from fileKeywords a
left join file b on a.docid=b.record_number
where (a.dataid=1037 and a.value='atb') or (a.dataid=1038 and a.value=11) or (a.dataid=1039 and a.value='4.57')