sql一对多 多行匹配

发布网友 发布时间：2024-10-22 11:55

我来回答

共1个回答

热心网友 时间：2024-10-29 01:54

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')

热心网友 时间：2024-10-29 01:55

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')

热心网友 时间：2024-10-29 01:55

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')

热心网友 时间：2024-10-29 01:55

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')

热心网友 时间：2024-10-29 01:55

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')

热心网友 时间：2024-10-29 01:55

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')

热心网友 时间：2024-10-29 01:55

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')