三个access查询实用技巧

时　间:2017-07-17 01:36:31
作　者:Allen Lee   ID：13894  城市：厦门
摘　要:查询表名称、联合查询及多表外联查询的SQL写法技巧。
正　文:

select name from MSysObjects where type=1 and flags=0 MSysObjects

select 'wallimn' 
    union all 
    select name from MSysObjects 

　　select 'wallimn' from dual 
    union all 
    select name from MSysObjects

Select * FROM (aa LEFT JOIN bb ON aa.a = bb.a ) LEFT JOIN cc ON cc.a = bb.a; 

Select * FROM (aa LEFT JOIN bb ON aa.a=bb.a) LEFT JOIN cc ON(bb.a=cc.a and bb.b=cc.b) 

点击下载此附件

点击下载此附件

(1)、

Select * FROM URL as a LEFT OUTER JOIN MobileAfter as b ON a.URL = b.URL 

(2)、

Select * FROM (URL as a LEFT OUTER JOIN MobileAfter as b ON a.URL= b.URL) LEFT OUTER JOIN MobileBefore as c ONc.URL=a.URL 

(3)、

Select * INTO Ttable1 FROM ((((URL as a 
LEFT OUTER JOIN MobileAfter as b ON a.URL=b.URL) 
LEFT OUTER JOIN MobileBefore as c ON c.URL=a.URL) 
LEFT OUTER JOIN TeleCOM as d ON d.URL=a.URL) 
LEFT OUTER JOIN UniCOM as e ON e.URL=a.URL)