Hi jaro,
I have a requiremnt that, there is one csv file having two fields(institution_id,consortia_id). I have one DB table accounts which is having the entry of booth the fields in the code column of the accounts table and generate primary key for both now i want to fetch primary key fro them
example:-
file name:- consortia_memberds
fields:- institution_id,consortia_id
records are in the file like this
1002, “TWN”
1003,“SPM”
here intitution_id is parent and the consortia_id is the child.
I loaded seperate files for both of them which generated primary key for them.
Now i want to find primary key for institution_id and the consortia_id from DB after and want to make entry in the parent_child table.
My issue is that how can i get key fot the field institution_id and the consortia_id altogether.
Please help if have any idea…
Thanks