草庐IT

mysql - 具有多个 AND OR WHERE 条件的复杂 MySQL 查询

我有一张表格可以帮助选择产品。我想有一个查询,我在哪里得到每条记录:category_id='M10'andband_id='010'ORcategory_id='M10'andband_id='020'ANDcategory_id='M50'andband_id='010'ORcategory_id='M50'andband_id='020'我的查询:SELECTproduct.entry_idASentry_id,helpme.item_idASproduct_idFROMinbound_help_me_choosehelpmeLEFTJOINexp_channel_titlesp