为何总是提示语法错误？

[user2003]

select c.fbillno,c.fdate,e.fitemid,e.fqty,e.fprice,e.fsourcebillno
from icsaleentry as e
left join icsale as c
left join (
select b.fbillno,be.fitemid,be.fqty,be.fauxprice from icstockbillentry as be
left join icstockbill as b
on be.finterid = b.finterid
) as ic
on e.finterid=c.finterid
and e.finterid=ic.finterid
and e.fitemid=ic.fitemid
and be.fqty = ic.fqty
and c.fdate between '2009-01-01' and '2009-03-31'

[huminghua]

哇！这么多的答案！ 哈哈！帮顶啊！77.。。。。。

[仙道彰]

select c.fbillno,c.fdate,e.fitemid,e.fqty,e.fprice,e.fsourcebillno
from icsaleentry as e
left join icsale as c on e.finterid=c.finteridleft join (
select b.fbillno,be.fitemid,be.fqty,be.fauxprice from icstockbillentry as be
left join icstockbill as b
on be.finterid = b.finterid
) as ic
on.........
and e.finterid=ic.finterid
and e.fitemid=ic.fitemid
and be.fqty = ic.fqty
and c.fdate between '2009-01-01' and '2009-03-31'

[SQL77]

select c.fbillno,c.fdate,e.fitemid,e.fqty,e.fprice,e.fsourcebillno
from icsaleentry as e
left join icsale as c
on e.finterid=c.finterid
left join (
select b.fbillno,be.fitemid,be.fqty,be.fauxprice from icstockbillentry as be
left join icstockbill as b
on be.finterid = b.finterid
) as ic
--on e.finterid=c.finterid
and e.finterid=ic.finterid
and e.fitemid=ic.fitemid
and be.fqty = ic.fqty
and c.fdate between '2009-01-01' and '2009-03-31'

[htl258_Tony]

select c.fbillno,c.fdate,e.fitemid,e.fqty,e.fprice,e.fsourcebillno
from icsaleentry as e 
	left join icsale as c 
		on e.finterid=c.finterid
	left join (
		select b.finterid,b.fbillno,be.fitemid,be.fqty,be.fauxprice 
		from icstockbillentry as be
			left join icstockbill as b
				on be.finterid = b.finterid
		) as ic
		on e.finterid=ic.finterid
		and e.fitemid=ic.fitemid
		and be.fqty = ic.fqty
		and c.fdate between '2009-01-01' and '2009-03-31'

[老黎]

select c.fbillno,c.fdate,e.fitemid,e.fqty,e.fprice,e.fsourcebillno
from icsaleentry as e 
     left join icsale as c on e.finterid=c.finterid and c.fdate between '2009-01-01' and '2009-03-31'
     left join (
				select b.fbillno,be.fitemid,be.fqty,be.fauxprice 
                from icstockbillentry as be
			         left join icstockbill as b
				on be.finterid = b.finterid
			   ) as ic on e.finterid=ic.finterid and e.fitemid=ic.fitemid and be.fqty = ic.fqty