very simple: How can I multiply tables?

From: "Mikhail V(dot) Majorov" <mik(at)ttn(dot)ru>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: very simple: How can I multiply tables?
Date: 2001-02-14 14:49:01
Message-ID: 3A8A9ADD.395CD83E@ttn.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Riebs, Andy 2001-02-14 14:55:55 RE: Crash-me of PostgreSQL
Previous Message Poul L. Christiansen 2001-02-14 14:26:38 Re: Crash-me of PostgreSQL