On 26/03/2008 12:26, Sam Mason wrote:
> INSERT INTO f2_tempfac
> SELECT (row_tempf).*;
Does this depend on the column order in table f2_tempfac being the same
as that in the SELECT that produced row_tempf?
Or will row_tempf.foo automagically get matched with column
f2_tempfac.foo, etc?
Ray.
---------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod(at)iol(dot)ie
---------------------------------------------------------------