Hi,
I'm new to this and though I think this is a simple operation, I can't
find the answer here or in the documentation.
What is the best way to take two columns from a Table and copy them to
a new Table. E.g. Table 1 has columns a,b,c,d with data, I want to
create a new Table, Table 2, with two columns equal to b and d from
Table 1.
I'm not sure whether the best approach is to take the column names
then copy rows in to the new table or whether it's possible to grab
whole columns from Table 1 and copy directly to Table 2.
Any guidance much appreciated.
thanks,
Will