ВЫБЕРИТЕ * ГДЕ НЕ СУЩЕСТВУЕТ

SELECT * FROM employees WHERE name NOT IN (SELECT name FROM eotm_dyn)

ИЛИ

SELECT * FROM employees WHERE NOT EXISTS (SELECT * FROM eotm_dyn WHERE eotm_dyn.name = employees.name)

ИЛИ

SELECT * FROM employees LEFT OUTER JOIN eotm_dyn ON eotm_dyn.name = employees.name WHERE eotm_dyn IS NULL

mysql-table

mysql

2022-11-16T14:40:39+00:00