RE: SQL Select Problem

From: Mike Pantzopoulos - (H/O)

I'm trying to use the following select as a sub select in a CREATE TABLE
AS (....) statement. In essence I want to create a table using a 20 byte
field plus all the fields from the $POSTCODE table (actually a DS). The
resulting table will be populated with another SQL INSERT statement:

select '                    ',   * from $postcode

When the asterisk doesn't work (for example, when I do a join where I only
want one field from one file, but all of them from the second), I can
usually get it to work by qualifying it.  This should work:

 select '                    ', $postcode.* from $postcode

Joe