Hi all,
Something as simple as
SELECT * INTO tblcopy FROM tbl;
(where tbl is an existing table) gets the following error:
SQL error: near "INTO": syntax error
[version: 3.4.2 on Windows XP]
I note that this syntax is not mentioned on the supported SQL syntax web
page for SELECT, but it's also not mentioned AFAICT in the unsupported
features list on the wiki.
Am I missing something simple, or is "SELECT INTO" definitely not supported?
Can anybody help with a workaround that doesn't need an explict (and
rather long) list of fields in the 3-table join that is my real
non-simple requirement?
Thanks in advance,
John
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
