SELECt DISTINCT Camera.*FROM Camera c INNER JOIN cameras_features fc1 ON c.id = fc1.camera_id AND fc1.feature_id = 1 INNER JOIN cameras_features fc2 ON c.id = fc2.camera_id AND fc2.feature_id = 2
此处发生的情况是将摄像机筛选为功能1的摄像机，然后在该组中将摄像机筛选为功能2的摄像机。
SELECt DISTINCT Camera.*FROM Camera c INNER JOIN cameras_features fc1 ON c.id = fc1.camera_id AND fc1.feature_id = 1 INNER JOIN cameras_features fc2 ON c.id = fc2.camera_id AND fc2.feature_id = 2
此处发生的情况是将摄像机筛选为功能1的摄像机，然后在该组中将摄像机筛选为功能2的摄像机。
名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
