简单的sql 语句(在线)

Question

table cl160:
            cl160_pur_no      cl160_vendor_no  cl160_three_sub
                0002             A021              0101
                0003             B021              0201              
table cl100:
            cl100_three_sub     cl100_three_resume
                0101                 one
                0201                 two
sql:
    select CL160_PUR_NO,CL160_VENDOR_NO，CL100_THREE_SUB,CL100_SUB_NAME from msdba.cl160,MSDBA.CL100 where  CL100_THREE_SUB in (SELECT CL160_THREE_SUB FROM MSDBA.CL160);
我想查询出：
       cl160_pur_no      cl160_vendor_no  cl160_three_sub  cl100_three_resume
           0002             A021              0101             one
           0003             B021              0201             two

Answer 1

select a.CL160_PUR_NO,a.CL160_VENDOR_NO,b.CL100_THREE_SUB,b.CL100_SUB_NAME 
from table cl160 a,table cl100 b
where a.cl160_three_sub=b.cl100_three_sub

Answer 2

更正:select a.CL160_PUR_NO,a.CL160_VENDOR_NO,a.CL160_THREE_SUB,b.CL100_three_resume 
from  cl160 a, cl100 b
where a.cl160_three_sub=b.cl100_three_sub

Answer 3

谢谢啦，原来要取别名才可以。
 sbaz(万神渡劫) from table cl160 a,table cl100 b 是行不通的，看来和我一样的不仔细，哈哈! table 就不用了吧