Re: [SQL] join two tables with sharing some columns between two

2006-07-03 Thread Thomas Beutin
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

Re: [SQL] join two tables with sharing some columns between two

2006-07-02 Thread Phillip Smith
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

[SQL] join two tables with sharing some columns between two

2006-07-02 Thread filippo
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_