very simple: How can I multiply tables? - Mailing list pgsql-general

Hi, question

How can I multiply tables using SELECT?

Table 1

id     surname
--------------
1    AAA
2    BBB
3    CCC
4    DDD

Table 2

dt
---
12
35

RESULT

id    surname        dt
---------------------------
1    AAA        12
2    BBB        12
3    CCC        12
4    DDD        12
1    AAA        35
2    BBB        35
3    CCC        35
4    DDD        35