Sql Join Insert Query

write like this

Select E.Loan_code,E.Loan_type,E.Loan_Sanc,E.Intr_Type,
F.Chk_Num,F.Chk_Amount from BankDetails E join BankCheckDet F on E.Loan_code=F.Loan_code

Regards,
Iftikar

Hi,
   But then what it does , it fetches Loan_code colmn twice for join query

You need to insert the loan code first in your second table


Regards,
Iftikar

Hi
plz hav luk to this query it  inserts records into second table based on PK of first table but if  I try to retrive these tables by select join it is not showing any records


Insert Query:

Insert Into BankCheckDet (chk_Num,chk_Amt,Bank_Name)values(166,890000,'Indus bank') Select E.* From BankDetails E Left Join BankCheckDet F On E.Loan_code=F.Loan_code where E.Loan_code =4


Select Join Query:
Select E.* ,F.* from BankDetails E join BankCheckDet F on E.Loan_code=F.Loan_code

Plz help...

Hi,
        If you want only single record for each Loan_Code in your second table, then declare Loan_Code itself as primary key in your second table. Then you no need any join. We declare FK keeping in mind that it is a child table where parent id can be repeated. Let me know if you need something else.

Regards,
Iftikar