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;
還有人在嗎？請教一個SQL問題。誰能幫看是什麽問題，謝謝。
小謀 (2010-05-30 15:28:37) 評論 (2)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;