1

Topic: How to make the Cartesian product (Cartesian product) with the same table

There is a table (P1) it is necessary to make the Cartesian product with it that eats P1XP1

2

Re: How to make the Cartesian product (Cartesian product) with the same table

And what difficulties?

3

Re: How to make the Cartesian product (Cartesian product) with the same table

wrote:

QWASQ1;

select t1. *, t2.* from p1 t1, p2 t2

I helped?

No. Emu/it should not connect P1 c P2.
Regards
Maxim

4

Re: How to make the Cartesian product (Cartesian product) with the same table

Washes, the HARDWARE generally  it is necessary

5

Re: How to make the Cartesian product (Cartesian product) with the same table

Select * from table1 t1, table1 t2
Or
Select * from table1 t1 cross join table1 t2

6

Re: How to make the Cartesian product (Cartesian product) with the same table

andreymx wrote:

washes, the HARDWARE generally  it is necessary

No,  the vulgar Karteziansky product of two normalized  is necessary, is not mandatory