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.