[prev in list] [next in list] [prev in thread] [next in thread]
List: postgresql-sql
Subject: [SQL] join two tables with sharing some columns between two
From: "filippo" <filippo2991 () virgilio ! it>
Date: 2006-06-26 13:39:11
Message-ID: 1151329151.231866.175920 () u72g2000cwu ! googlegroups ! com
[Download RAW message or body]
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_name
car_description
date_arrival
date_departure
the id is the primary key for the three tables and it's unique for the
three (id in table1 cannot be in table2, I use the same counter to
generate the id for table1 and table2).
I is possible to create such a query?
Thanks
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic