又一个关于SQL语句的问题！(20分)

易

易名烦

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-12-03

• #1

我的语句为：
INSERT INTO CZBYCDK SELECT * FROM DISPOSALCZB WHERE HTBH IN (SELECT DISTINCT POBH FROM CZBPSR)
其中好象HTBH IN (SELECT DISTINCT POBH FROM CZBPSR)错误，原因是HTBH和POBH字段名不一致。
请问：怎么改可以通过（最好一条语句）！

 

J

jsxjd

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-12-03

• #2

INSERT INTO CZBYCDK SELECT * FROM DISPOSALCZB WHERE HTBH IN (SELECT DISTINCT POBH HTBH FROM CZBPSR)
////

 

C

cyf_00002

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-12-03

• #3

同上
也可以
INSERT INTO CZBYCDK SELECT * FROM DISPOSALCZB WHERE HTBH IN (SELECT DISTINCT POBH as HTBH FROM CZBPSR)

 

易

易名烦

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-12-03

• #4

哈，不是这个问题，是我的字段不等，一人一半的分，麻烦给看看其它问题.