我执行的语句是这样的
Query4.SQL.Add('select (case when a.Responsible<>'''' then a.Responsible else b.Responsible end) as 姓名,a.totaljob,a.fault+b.fault from "e:\btotal.dbf" a, "e:\ctotal.dbf" b') ;
Query4.Open;如果把(case when a.Responsible<>'''' then a.Responsible else b.Responsible end) as 姓名,这段去掉就没问题了,可我应该没写错啊
Query4.SQL.Add('select (case when a.Responsible<>'''' then a.Responsible else b.Responsible end) as 姓名,a.totaljob,a.fault+b.fault from "e:\btotal.dbf" a, "e:\ctotal.dbf" b') ;
Query4.Open;如果把(case when a.Responsible<>'''' then a.Responsible else b.Responsible end) as 姓名,这段去掉就没问题了,可我应该没写错啊
http://community.csdn.net/Expert/topic/5756/5756770.xml?temp=.7982447
上面是那个帖子的地址
ks_reny 兄你的应该是在SQL中做的查询,那是没错的