2007 Aug 29 12:14 PM
HI ,
i have 2 intenal tables of of one with data of name and another with fathers name .if i have to link these 2 tables in 3 table and i have to check the name and fathers name or correct and insert into 3rd table.
HI ,
i have 2 intenal tables of of one with data of name and another with fathers name .if i have to link these 2 tables in 3 table and i have to check the name and fathers name or correct and insert into 3rd table.
2007 Aug 29 12:18 PM
2007 Aug 29 12:18 PM
From which table u r taking, so ur name and fathers name is linked how?
2007 Aug 29 12:18 PM
select afield1 afield2 bfield1 into (table3-field1, table3-field2, table3-field3) from table1 as a inner join table2 as b on aname eq b~name
where ....
2007 Aug 29 12:21 PM
actually i have name of 5 records and fathers name i dont know how to link it.