Topic: Что не так в записи условия SQL ?
Прошу подсказать в чём ошибка?
При такой записи условия всё работает:
SELECT
contact.name,
contact.phone,
contact.phone2,
groups.groupName,
organization.organization,
department.department,
otdel.otdel,
room.room,
contact.num,
post.post
FROM contact
LEFT OUTER JOIN groups ON contact.id_groups=groups.id
LEFT OUTER JOIN organization ON contact.id_organization=organization.id
LEFT OUTER JOIN department ON contact.id_department=department.id
LEFT OUTER JOIN otdel ON contact.id_otdel=otdel.id
LEFT OUTER JOIN room ON contact.id_room=room.id
LEFT OUTER JOIN post ON contact.id_post=post.id
WHERE contact.id_organization={cbOrg} AND contact.name<>'ВАКАНСІЯ'
А если добавляю ещё одно условие, то, как говорится, " усё пропало, шеф!":
SELECT
contact.name,
contact.phone,
contact.phone2,
groups.groupName,
organization.organization,
department.department,
otdel.otdel,
room.room,
contact.num,
contact.note,
post.post
FROM contact
LEFT OUTER JOIN groups ON contact.id_groups=groups.id
LEFT OUTER JOIN organization ON contact.id_organization=organization.id
LEFT OUTER JOIN department ON contact.id_department=department.id
LEFT OUTER JOIN otdel ON contact.id_otdel=otdel.id
LEFT OUTER JOIN room ON contact.id_room=room.id
LEFT OUTER JOIN post ON contact.id_post=post.id
WHERE contact.id_organization={cbOrg} AND contact.name<>'ВАКАНСІЯ' AND contact.note<>'ДЕКРЕТ'