Hi,
filippo wrote:
> I have two tables like these: (this is an example, the actual tables
> have diffferent fields and meanings)
>
> TABLE1
> id
> person_name
> date_arrival
> date_departure
>
> TABLE2
> id
> car_description
> date_arrival
> date_departure
>
> I'd like to make a query to have s
ELECT INTO...
Cheers,
-p
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
On Behalf Of filippo
Sent: Monday, 26 June 2006 23:39
To: pgsql-sql@postgresql.org
Subject: [SQL] join two tables with sharing some columns between two
Hi,
I have two tables like these: (this is
Hi,
I have two tables like these: (this is an example, the actual tables
have diffferent fields and meanings)
TABLE1
id
person_name
date_arrival
date_departure
TABLE2
id
car_description
date_arrival
date_departure
I'd like to make a query to have such resulting table
RESULTING_TABLE
id
person_