Storing results from a Query in an existing Table

2002-10-13 Thread Tim Johnson
Hello All: I have learned to extract columns from one table and create a new table from those columns->i.e: CREATE TABLE Wines SELECT Country,Varietal,Producer,Vineyard,Year,Size FROM AH; Now I would like to SELECT the same columns from other tables and "append" them to Wines. I have trie

Re: Storing results from a Query in an existing Table

2002-10-13 Thread Paul DuBois
At 9:03 -0800 10/12/02, Tim Johnson wrote: >Hello All: > I have learned to extract columns from one table and >create a new table from those columns->i.e: > >CREATE TABLE Wines SELECT >Country,Varietal,Producer,Vineyard,Year,Size FROM AH; > >Now I would like to SELECT the same columns from ot

Re: Storing results from a Query in an existing Table

2002-10-13 Thread Insanely Great
://www.webyog.com/sqlyog - Original Message - From: "Tim Johnson" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, October 12, 2002 10:33 PM Subject: Storing results from a Query in an existing Table > Hello All: > I have learned to extract columns from one ta