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
If I understand correctly... I think this should work: SELECT table1.id, table1.person_name, table2.car_description, table1.date_arrival, table1.date_departure FROMtable1, table2 WHERE table1.id = table2.id ; Assuming the date