i have created two tables in SQL Database
TableA: Columns Names; ID, Name;
TableB: Columns Names: E_Id, DOB;
TableA: ID primary KEY, TableB: E_Id Foreign KEY
TableA ID Name
1 AAAA
2 BBBB
how to reflect TableA of ID Second TableB of E_ID
TableB E_ID DOB
12/12/1998
15/09/1994
only Insert ID in TableA. whenever Enter ID in TableA, at the same time
how to reflect E_ID in TableB.
after that reflect TableB in E_ID
how to get this OUTPUT
TableB E_ID DOB
1 12/12/1998
2 15/09/1994
now TableA ID and TableB E_ID are SAME.
What I have tried:
SELECT * INTO TableB
FROM TableA
WHERE ID IN
(SELECT ID FROM TableB)