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
