'How can we print 2 tables with all columns in psql using single query?

We SELECT data from multiple tables in mysql or SQL Server with SELECT * FROM table1, table2;.

But in pgAdmin this query does not work like it should be.

Can anyone tell me how can I get my desired output with this or there's any mistake in this logic?



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source