RIGHT JOIN (or RIGHT OUTER JOIN): It’s the opposite of a LEFT JOIN. It keeps all rows from the right table and matches from ...
CREATE TABLE NICEFMT(ID BIGINT GENERATED BY DEFAULT AS IDENTITY primary key,MKEY VARCHAR,DATA VARCHAR,VERSION INTEGER,TORF VARCHAR,STATE VARCHAR,DATUM TIMESTAMP,LOGIN VARCHAR); insert into NICEFMT ( ...