還有人在嗎？請教一個SQL問題。誰能幫看是什麽問題，謝謝。

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;

[kzc866]

你陷職場誤區了。 嗬嗬 ，轉出來吧， 嗬嗬。有笑有哭，又學又念。有道是：機關算盡太聰明 反誤了卿卿性命。嘿嘿

[balancedview]

insert into lib.temp
select
a.id,
a.dob,
b.emp,
b.salary
from
employ as a,personel as b
where a.id = b.emp;