Many thanks......I really must re-read my SQL book.

> > It is possible to do the following using some SQL script or must I
> > resort to coding an app?
> >
> > TableA
> >
> > A_ID
> > B_ID
> > C_ID
> > X_ID
> >
> > For all entries in Table A, I would like to extract A_ID and X_ID and
> > insert them into TableZ:
> >
> > TableZ
> >
> > Z_ID
> > A_ID
> > X_ID
> >
>
> insert into tableZ(a_id, x_id)
> select a_id, x_id from tableA
>
> Sasha
>