Ошибка

SQL-запрос :

SELECT tbl_bonus_users.t_user_id, tbl_bonus_works.t_work_description
FROM tbl_bonus_users, tbl_bonus_works
WHERE tbl_bonus_users.t_user_id = "dens" AND tbl_bonus_users.t_user_id
IN (


SELECT tbl_bonus_check_access.t_group_rule_id
FROM tbl_bonus_check_access
WHERE tbl_bonus_check_access.t_inspector_id = tbl_bonus_users.t_user_id
) AND tbl_bonus_users.t_user_id = tbl_bonus_users.t_user_id
LIMIT 0, 30

Ответ MySQL:


You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT tbl_bonus_check_access.t_group_rule_id FROM tbl_bonus_ch

пробовал и так
Ошибка

SQL-запрос :

SELECT b.t_user_id, d.t_work_description
FROM tbl_bonus_users AS a, tbl_bonus_users AS b, tbl_bonus_works AS d
WHERE a.t_user_id = "dens" AND b.t_user_id
IN (


SELECT c.t_group_rule_id
FROM tbl_bonus_check_access AS c
WHERE c.t_inspector_id = a.t_user_id
) AND b.t_user_id = d.t_user_id
LIMIT 0, 30

Ответ MySQL:


You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT c.t_group_rule_id FROM tbl_bonus_check_access AS c WHERE
Назад