SQLite 3.27

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE Table1 (`ID` INTEGER, `TEMPERATURE` INTEGER, `DESCR` TEXT, `NUMB` INTEGER);

INSERT INTO Table1 (`ID`, `TEMPERATURE`, `DESCR`, `NUMB`) VALUES
  ('32', '23', 'Y', '23'),
  ('47', '54', 'N', '24');
CREATE TABLE Table2 (`ID` INTEGER, `COLOR 1` TEXT, `COLOR 2` TEXT, `COLOR 3` TEXT);
INSERT INTO Table2 (`ID`, `COLOR 1`, `COLOR 2`, `COLOR 3`) VALUES
  ('32', 'RED', 'BLUE', 'GREEN'),
  ('47', 'BLUE', 'PURPLE', 'RED');
SELECT *
FROM Table1 INNER JOIN Table2
USING(id);


ID
TEMPERATURE
DESCR
NUMB
COLOR 1
COLOR 2
COLOR 3


32
23
Y
23
RED
BLUE
GREEN

47
54
N
24
BLUE
PURPLE
RED