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

Thanks