SQLize | PHPize | SQLtest

create table a(cod int, name text, eden text, cost float); insert into a (cod, name, eden, cost) values(4640, "плитка неополь", "шт", 25.50); insert into a (cod, name, eden, cost) values(4778, "плитка экстра", "шт", 14.0); insert into a (cod, name, eden, cost) values(4788, "клей монолит", "шт", 100.00); insert into a (cod, name, eden, cost) values(4796, "гипс", "кг", 10.00); insert into a (cod, name, eden, cost) values(4899, "шпатель 201", "шт", 21.50); create table b(cod int, name text, eden text, cost float); insert into b (cod, name, eden, cost) values(4640, "плитка неополь", "шт", 25.50); insert into b (cod, name, eden, cost) values(4779, "плитка лазурь", "шт", 14.50); insert into b (cod, name, eden, cost) values(4780, "клей пва", "кг", 45.00); insert into b (cod, name, eden, cost) values(4788, "клей монолит", "шт", 100.00); insert into b (cod, name, eden, cost) values(4903, "шпатель 201", "шт", 21.50); select cod, name, eden, cost from a MINUS select cod, name, eden, cost from b;