Hi,
Hi I want to Insert Values into 2nd table where Fk in 2nd tabel is equal to PK in 1st table. Here if I Insert Values into 2nd table, Pk Values should not be Duplicated in 1st table.
What should be the INSERT JOIN Query...
| Loan_code | Loan_Type | Loan_Sanc | Intr_Type |
| 1 | Home | 30000 | Variable |
| 2 | car | 40000 | Fixed |
| 3 | Bike | 50000 | Variable |
| 4 | Personal | 60000 | Fixed |
| Chk_Num | Chk_Amount | Loan_code |
|
|
|
|
|
|
Plz Help