關聯查詢

发表于:2007-05-25来源:作者:点击数: 标签:關聯查詢Select

select resak.resak001,resak.resak002,resak.resak005,resak.resak006, resal.resal001 AS EXPR3, resak.resak015 AS EXPR4, resal.resal002 
FROM             resak INNER JOIN
                          resal ON resak.resak015 = resal.resal001

where resak.resak001!='9999' and resak.resak001 !='1947'

原文转自:http://www.ltesting.net