Hi, If I have: 1.) table car with columns index and name 2.) table driver with columns index, name and car_index
and query: SELECT d.*, c.* FROM driver as d LEFT OUTER JOIN car AS c ON d.car_index=c.index; How can I get results that have distinct names for columns (ex. d.name, d.index, c.name, c.index,...)? tnx boris ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org