> 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