select a.personid as personid,a.drinksign as cjjg,a.enterroomtime as cjsj,b.hname as hname,b.workno as workno from z_jcyy_waitingdutypersonnel a,z_jcyy_basepersonnel b left join z_jcyy_waitingdutypersonnel on z_jcyy_waitingdutypersonnel.personid=z_jcyy_basepersonnel.personid'
str:string;
begin
str:='select a.personid as personid,a.drinksign';
str:=str+' as cjjg,a.enterroomtime as cjsj,b.hname as hname,b.workno';
str:=str+' as workno from z_jcyy_waitingdutypersonnel a,z_jcyy_basepersonnel b left join
str:=str+'z_jcyy_waitingdutypersonnel on z_jcyy_waitingdutypersonnel.personid=z_jcyy_basepersonnel.personid';
end;
SQL.Text:='select a.personid as personid,a.drinksign as cjjg,a.enterroomtime as cjsj,'+
'b.hname as hname,b.workno as workno from z_jcyy_waitingdutypersonnel a,'+
'z_jcyy_basepersonnel b left join z_jcyy_waitingdutypersonnel on '+
'z_jcyy_waitingdutypersonnel.personid=z_jcyy_basepersonnel.personid';
类似这样分开就可以了
sqlstr:string;
begin
sqlstr:='select a.personid as personid,a.drinksign as cjjg,a.enterroomtime as cjsj,';
sqlstr:=sqlstr+'b.hname as hname,b.workno as workno from ';
sqlstr:=sqlstr+'z_jcyy_waitingdutypersonnela,z_jcyy_basepersonnel b left join z_jcyy_waitingdutypersonnel on z_jcyy_waitingdutypersonnel.personid=z_jcyy_basepersonnel.personid';
end;