Hi, I tried the following for joining multiple tables by id, and select all into a new table.
However, it will not work because id gets repeated. How to select all except one column? select a.*, b.*, c.*, d.* into new_table from a_table a join b_table b on a.id=b.id join c_table c on a.id=c.id join d_table d on a.id=d.id Looking forward to hearing from you. Regards, David
_______________________________________________ postgis-users mailing list postgis-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/postgis-users