While inserting records into a table A, if a need arises to fill a column with value from a table B, then use the following sql
insert into "CLASSICCARS"."EMPLOYEE"
(
"EMPLOYEENUMBER",
"OFFICECODE"
)
values
(
1703,
(select max(officecode) from classiccars.OFFICE)
)
