SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
create table a ( _id int, name varchar(32), code int ); create table b ( clientId int, itemId int, itemType int ); insert into a values (1, 'Item 1', 10), (2, 'Item 2', 12); insert into b values (1, 1, 12); select a.*, exists (select 1 from b where b.itemId = a._id) foo from a;
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear