SQL 與 Access 之間的差異

Access對於SQL的語法較為嚴謹，Num1 && Amt9 兩個欄位型態為數值，請注意以下差別

--使用Access Num1 & Amt9 兩個欄位型態為數值
select [name],dept,a.* 
from GDEPTF d 
right join 
(
 select left(dept,2) as SQ1, sum(num1) as N1
 from GPRSNF where yy='097' and (num1<>0 or amt9<>0)
 group by left(dept,2)
) a on a.SQ1=left(d.dept,2) 
where right(d.dept,3)='000'

--使用SQL Server 型態方式寫成字串一樣可以執行
select [name],dept,a.* 
from GDEPTF d 
right join 
(
 select left(dept,2) as SQ1, sum(num1) as N1
 from GPRSNF where yy='097' and (num1<>'0' or amt9<>'0')
 group by left(dept,2)
) a on SQ1=left(d.dept,2) and right(dept,3)='000'