Given two columns, t1 with distinct values, but a superset of t2, how is it possible to operate over t1 to subtract the elements of t2 of t1? I utilize MySQL 5.7
CREATE TABLE IF NOT EXISTS t1 (
id_ INTEGER NOT NULL,
value1 INT NOT NULL
INSERT INTO t1 (id_, value1) VALUES
(1),
(2),
(3),
(4),
(5),
(6),
(7),
(8)
CREATE TABLE IF NOT EXISTS t1 (
id_ INTEGER NOT NULL,
value1 INT NOT NULL
INSERT INTO t2 (id_, value2) VALUES
(1),
(2),
(3),
(4)
Asked by Bruno Lobo
(127 rep)
May 27, 2021, 12:18 PM
Last activity: May 28, 2021, 09:16 AM
Last activity: May 28, 2021, 09:16 AM