got error message as: ...Syntax error: expected something between the word 'a' and '.'. 很简单的一短code: insert into lib.temp select a.id, a.dob, b.emp, b.salary from employ a,personel b where a.id = b.emp; quit;