Postgres 12 | db<>fiddle

select version();

version
PostgreSQL 12.6 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.3.1 20191121 (Red Hat 8.3.1-5), 64-bit
…

hidden batch(es)

CREATE TABLE meal ( mname TEXT NOT NULL );

✓

hidden batch(es)

CREATE TABLE drink ( dname TEXT NOT NULL )

✓

hidden batch(es)

INSERT INTO meal (mname) VALUES ('Omlette'), ('Fried Egg'), ('Sausage');

3 rows affected

hidden batch(es)

INSERT INTO drink (dname) VALUES ('Coffee'), ('Tea'), ('Orange Juice');

3 rows affected

hidden batch(es)

SELECT * FROM meal, drink;

hidden batch(es)

SELECT * FROM meal CROSS JOIN drink;

hidden batch(es)

SELECT m.mname, d.dname FROM meal m CROSS JOIN drink d;

hidden batch(es)

SELECT m.mname, d.dname FROM meal m JOIN drink d ON TRUE; -- or 1 = 1;

hidden batch(es)