CROSS JOIN SQL

What does SQL CROSS JOIN do?

It produces number of rows in  the first table multiplied by the number of rows in the second table - a Cartesian Product.

Syntax 


FROM table1
CROSS JOIN table2;

What are the options to create table in PostgreSQL

Here is a list of ways you can Create Table in PostgreSQL

Command line

PgAdmin III

phpPgAdmin

Which way do you prefer?