SQLize | PHPize | SQLtest

create table test_w (cnt int, empl varchar(50), id int); ------------------------------------------------------ insert into test_w values (20, 'Слесарь', 2); insert into test_w values (30, 'Монтажник', 2); insert into test_w values (20, 'Монтажник', 3); insert into test_w values (50, 'Уборщик', 3); insert into test_w values (20, 'Директор', 1); create table test_m (zarplata int, empl2 varchar(50), id int); insert into test_m values (12000, 'Слесарь',2); insert into test_m values (22000, 'Монтажник',2); insert into test_m values (32000, 'Уборщик',3); insert into test_m values (12000, 'Директор',0); select t1.*, t2.* --t2.empl as emp1 from test_m t2 left join test_w t1 --left join test_w t1 on (t1.empl <> t2.empl2 and t1.id <> t2.id) --and t2.id with (2,1)) --where t2.id =2