Insert Problem

[OOzy]

Table: Dept
Dept_ID Dept_Name
{7CFBF07C-0123} Engineering
{864CB2DF-519E} Planning
{344FDBBF-5FDD} Accounting


Table: Employee
Emp_ID FN LN Dept_ID
5562 John Smith ------


I have the above two tables. John Smith is from the Engineering Dept. I tried to insert his info in the Employee but I couldn’t because of the Dept_ID integrity. How can I write an Insert statement to automatically get the Dept_ID from the Dept Table and insert in the Employee table along for the Emp_ID, FN, LN which are known?

Check this

http://www.geocities.com/oozypal/IUI/

if you can't read the tables.

 

[angiole]

OOzy, How are these 2 tables linked? AA 8~)

 

[barbarul2001]

insert into Employee
select 5562, John Smith , Dept.Dept_ID from Dept
where Dept_Name='Engineering'

web/sql developer