[![enter image description here][1]][1]good day to you all.
I have a table with some field like attached file T_Jadwal2.jpg. https://i.stack.imgur.com/mPuBg.jpg I need the the table insert to other table with the difference way format like T_Jadwal3.jpg https://i.stack.imgur.com/hRg7y.jpg Kindly to have the solution in query to append the T_Jadwal2 to T_Jadwal3
Thank you.
Regards, Fernando
Create a union query like this:
Use this as source in your append query.