Table1: empid (primary key), empdoj, empamt, empadd
Table2: emploanid(primary key), empph, empdob
Table3: empsal,emploan,empint
I have to use empdoj, empamt, emploanid in table3 and I have to search, update the details by using emploanid
MY WORKS IN DATABASE:
create table employee_detail (empcid varchar2(25) primary key, empdoj date, empamt varchar2(10),ampadd varchar2(10));
create table employee_deposit(loanid varchar(25) primary key, empph number(10), empdob date));
create table employee_sharecapital(loanid varchar2(25),empedoj date,empamt varchar2(10),empsal varchar2(10),emploan number(10));
i have to display & update in c# by using loan id in sharecapital table
Frond end : c#
Database : oracle
Thanks in advance.