Kindly help me in writing a query which picks the data from csv file and from matching column to the table structure already created. Let's say I've table with columns id, name, department(orderly as mentioned) On the other hand I've cav file with id, school, name, division, department(orderly as mentioned). Now I've to write a query to important data from cav to table and it should pick the data from right column.
Thanks in advance