日期:2014-05-19  浏览次数:20472 次

关于Access中建立查询sql的问题
现在我写了一段sql语句,我要在Access中建立这个查询,但是我简单的把它copy就报错,那位大虾能够知道下小弟,是不是在Access中有些sql的语法是不能用的呢?
select   c.instance,   c.usercallNo,   c.description,   c.status,   c.BranchID,   c.customerNo,   c.LOB,   c.BusUnit,   c.Market,   c.dept,
cy.yr,   cy.B_Jan,   cy.b_feb,   cy.b_mar,   cy.B_apr,   cy.b_may,   cy.b_jun,   cy.b_jul,   cy.b_aug,   cy.b_Sep,   cy.b_Oct,   cy.B_Nov,   cy.B_Dec,   cy.b_total,
cy.c_Jan,   cy.c_feb,   cy.c_mar,   cy.c_apr,   cy.c_may,   cy.c_jun,   cy.c_jul,   cy.c_aug,   cy.c_Sep,   cy.c_Oct,   cy.c_Nov,   cy.c_Dec,   cy.c_total,
cy.b_jobtodate,   cy.b_yeartodate,   cy.c_jobtodate,   cy.c_yeartodate,cm.bc01   as   MTDBillings,   (cm.cc01+cm.cc06)   as   MTDCost
from   tblcalls   c  
--Join   callyears
join   tblcallyears   cy   on   c.callNo=cy.callNo
--Join   MTD   Billing   and   MTD   Cost
join   tblcallmonths   cm   on   cm.callNo=c.callNo   and   cm.Month= '2007-07-01   00:00:00.000 '
where   c.instance= '657 '   and   c.branchID= '3 '  
order   by   c.dept,   c.usercallno,   cy.yr

------解决方案--------------------
報的錯誤是什麼?寫詳細點

或者
select c.instance, c.usercallNo, c.description, c.status, c.BranchID, c.customerNo, c.LOB, c.BusUnit, c.Market, c.dept,
cy.yr, cy.B_Jan, cy.b_feb, cy.b_mar, cy.B_apr, cy.b_may, cy.b_jun, cy.b_jul, cy.b_aug, cy.b_Sep, cy.b_Oct, cy.B_Nov, cy.B_Dec, cy.b_total,
cy.c_Jan, cy.c_feb, cy.c_mar, cy.c_apr, cy.c_may, cy.c_jun, cy.c_jul, cy.c_aug, cy.c_Sep, cy.c_Oct, cy.c_Nov, cy.c_Dec, cy.c_total,
cy.b_jobtodate, cy.b_yeartodate, cy.c_jobtodate, cy.c_yeartodate,cm.bc01 as MTDBillings, (cm.cc01+cm.cc06) as MTDCost
from (tblcalls c
inner join tblcallyears cy on c.callNo=cy.callNo)
inner join tblcallmonths cm on cm.callNo=c.callNo
where c.instance= '657 ' and c.branchID= '3 ' and cm.Month=#2007-07-01#
order by c.dept, c.usercallno, cy.yr