Insert into second table from first table

[EasyBoy2]

I am totally new to Teradata. I need help with SQL table syntax for creating, inserting table from other table
I do have one requirement.
1) Create one table called : Employee contains Emp_ID, First_Name, Last_Name etc..
2) Create second table called: Sales - Emp_ID, Sales_amout, Date etc.

Primary Key: EMP_ID on employee table
Foreign key: EMP_ID on Sales table reference Employee table.
I need to insert on sales table and it will automatically update employee table.
How would it be possible?

Can anyone please?
Its urgent.
Thanks all for your help