Как составить sql запрос?

Question

[Дмитрий]

Здравствуйте!
Не могу понять как можно сделать подобный запрос:

SELECT id FROM `cms3_objects` o 
JOIN `cms3_object_content` oc ON o.`id` = oc.`obj_id` 
WHERE (`field_id` = '911' AND `rel_val`='283367' 
AND `field_id` = '912' AND `rel_val`='800' 
AND `field_id` = '913' AND `rel_val`='66756')

Те запрос учитывает field_id у одного объекта все 3 условия!

Answer 1

[Rsa97]

Тремя JOIN'ами

SELECT `id` 
  FROM `cms3_objects` AS `o`
  JOIN `cms3_object_content` AS `t1` ON `t1`.`obj_id` = `o`.`id`
      AND `t1`.`field_id` = '911' AND `t1`.`rel_val`='283367'
  JOIN `cms3_object_content` AS `t2` ON `t2`.`obj_id` = `o`.`id`
      AND `t2`.`field_id` = '912' AND `t2`.`rel_val`='800'
  JOIN `cms3_object_content` AS `t3` ON `t3`.`obj_id` = `o`.`id`
      AND `t3`.`field_id` = '913' AND `t3`.`rel_val`='66756'