andrey24mayПодскажите, есть запрос

select staff.fio from wp_db_staff as staff

inner join wp_db_link as link ON staff.id = link.id_user
inner join wp_db_object as object ON object.id = link.id_object
inner join wp_db_spec as spec ON spec.id = link.id_spec



WHERE staff.mark = 5 AND object.id = 11 AND spec.id = 4

Так всё работает, но не работает, если я добавляю условие неважно к какой таблице с полем, например

select staff.fio from wp_db_staff as staff

inner join wp_db_link as link ON staff.id = link.id_user
inner join wp_db_object as object ON object.id = link.id_object
inner join wp_db_spec as spec ON spec.id = link.id_spec



WHERE staff.mark = 5 AND object.id = 11 AND spec.id = 4 AND object.id = 12

Так ничего не находит. Хотя должно. Где ошибка ?

серьёзно??? должно???
--------------------------------!!!!!!!!!!!!!!!!!!---------------------------!!!!!!!!!!!!!!!!!!
WHERE staff.mark = 5 AND object.id = 11 AND spec.id = 4 AND object.id = 12

серьёзно??? должно???
-------------------------------------------!!!!!!!!!!!!!!!!!!---------------------------!!!!!!!!!!!!!!!!!!
WHERE staff.mark = 5 AND object.id = 11 AND spec.id = 4 AND object.id = 12

==

object.id = 11 AND object.id = 12