On Jan 15, 2008, at 12:16 , Albe Laurenz wrote:
Because the SQL standard says so. ISO/IEC 9075-2, Chapter 14.8, Syntax Rule 9: "If the <insert column list> is omitted, then an <insert column list> that identifies all columns of T in the ascending sequence of their ordinal positions within T is implicit." You want an explicit <insert column list>: INSERT INTO dest_2 (user_id, product_id, permit_start_date, permit_end_date) SELECT ...
Thanks to both of you for this answer. - Tore. ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings