15 replies to this topic

[Vol Yip]

Well, to state the obvious, that suggests A.* does not expand to the sequence of columns that works when coded explicitly. In other words, A.* is apparently not type-compatible with your primary file definition whereas your explicit column-list is.
Is the explicit list in fact all the columns in table A in the order they were defined when the table was created or isn't it?

HTH.

Hi Richard,

Yes, the explict list in fact all the columns in table A in the order they were defined when the table was created.

Regards,

Vol