putting a select statement in a trigger

[dmcmillan]

My real problem is getting info from two other tables. I could just use
values (ld.company, ld.employee, etc. for the info from the table that the trigger is on (test.employee), but how would I get the info from the other two tables?
Thanks very much for any ideas.