TableA-TableB as SQL

The TableA and TableB as SQL

N.B. Some DBMSs may require quoted tables and fields names.

CREATE TABLE TableA (
IDFieldA INTEGER
, ValueFieldA INTEGER
);
INSERT INTO TableA VALUES (25,1);
INSERT INTO TableA VALUES (36,2);
INSERT INTO TableA VALUES (38,3);

CREATE TABLE TableB (
IDFieldB INTEGER
, ValueFieldB INTEGER
);
INSERT INTO TableB VALUES (36,287);
INSERT INTO TableB VALUES (37,311);
INSERT INTO TableB VALUES (38,127);
SELECT * FROM TableA;