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问题。谁能帮看是什么问题，谢谢。
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;
select
a.id,
a.dob,
b.emp,
b.salary
from
employ as a,personel as b
where a.id = b.emp;
登录后才可评论.
