SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
create table news ( id int, user_id int ); insert into news values (1, 1), (2, 1), (3, 2), (4,3); create table user_news ( news_id int, user_id int ); insert into user_news values (1, 1), (4,3); select * from news where not exists ( select 1 from user_news where user_news.news_id = news.id and user_news.user_id = news.user_id );
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear