Hi,

how di i nsert partial columns into tablex from table y

i have tableX which has 4 columns and i have tableY with 2 columns matches the data type of tableX

TableX
column1
column2
column3
column4

TableY

column1
column2



i would like to insert into table X column1 and 2 from TableY column1 and column2