On Mon, 21 May 2001 19:26:04 +0000 (UTC), dave go <godave621(at)yahoo(dot)com> wrote:
> Hi,
>
> I am trying create a new table A from table B. On B
> (b1, b2, b3, b4 ) I would like create a table A (a1,
> a2, a3) where a2 is b2 and b3.
>
> example:
> A)
>
> Id, lastname, Firstname, MInit
> ------------------------------
>
> B)
>
> Id, Name, MInit
> ---------------
>
SELECT Id, Firstname||' '||lastname as Name, MInit into B from A;