How to do a cartesian product on these tables (SQL)?

Question

First off, forgive my ignorance, but please I need help with this SQL how do I join or get Cartesian product on the first two tables called prov and proy, and the last table is what I want to get:

http://www.flickr.com/photos/63259070@N06/6927438513/

Answer 1

The keyword Cross Join returns the Cartesian product of rows from tables in the join.

It combines each row from the first table with each row from the second table.



Example of a implicit cross join (the system percieves it as a cross join) is:

Select * from employee, department;



example of a explicit cross join (by explictly using the keyword) is:

Select * from employee CROSS JOIN department;



You can use any of the above ways to get the Cartesian product in MS SQL.



Good Luck.!

Answer 2

If you really want a Cartesian product of two or more tables, just do a select without any JOIN or WHERE relational criteria. (I don't know what you'd possibly use that for tho)

Answer 3

Cartesian product: http://www.sql-tutorial.ru/en/book_cartesian_product.html