SQLize | PHPize | SQLtest

create table website_user ( phone text ); create table bot_user ( phone text, discr text not null ); insert into website_user (phone) values ('793838371'); insert into website_user (phone) values (null); insert into website_user (phone) values ('723123213123'); insert into bot_user (phone, discr) values ('793838371', 'viber'); insert into bot_user (phone, discr) values ('71111', 'whatsapp'); insert into bot_user (phone, discr) values (null, 'viber'); /* Выбираю вообще все телефоны из обоих таблиц, чтобы иметь полное представление о пользователях из любых источников */ select phone_number, exists(select * from website_user wu2 where wu2.phone = phone_number.phone) has_website, exists(select * from bot_user bu2 where bu2.phone = phone_number.phone and bu2.discr = 'viber') has_viber from ( select wu.phone from website_user wu where wu.phone is not null union select bu.phone from bot_user bu where bu.phone is not null ) phone_number;