需求如图所示:
根据ID查询,然后找出相同的两个字段的数据
select a.* from wp_cloud_products AS A inner join (SELECT * FROM wp_cloud_products WHERE ID = 42 )as B on A.shop_id = B.shop_id AND A.variation_number = B.variation_number
最终查询结果:
需求如图所示:
根据ID查询,然后找出相同的两个字段的数据
select a.* from wp_cloud_products AS A inner join (SELECT * FROM wp_cloud_products WHERE ID = 42 )as B on A.shop_id = B.shop_id AND A.variation_number = B.variation_number
最终查询结果: