执行下面代码 提示关键字"left" "order by" 错误 正确的方法我要如何表达 谢谢
begin
if edit1.text=' ' then
begin
showmessage(' not null');
abort;
end; with ADOQuery1 do
begin
sql.Clear;
sql.Add('SELECT MT001,MV002,ME002 FROM NK_ZLC..TEMP_3,'+
'LEFT JOIN WAY2006..CMSMV ON MT001=MV001,'+
'LEFT JOIN WAY2006..CMSME ON ME001=MV004,'+
'ORDER BY ME002 ASC');
open
end
end;end.
begin
if edit1.text=' ' then
begin
showmessage(' not null');
abort;
end; with ADOQuery1 do
begin
sql.Clear;
sql.Add('SELECT MT001,MV002,ME002 FROM NK_ZLC..TEMP_3,'+
'LEFT JOIN WAY2006..CMSMV ON MT001=MV001,'+
'LEFT JOIN WAY2006..CMSME ON ME001=MV004,'+
'ORDER BY ME002 ASC');
open
end
end;end.
' LEFT JOIN WAY2006..CMSMV ON MT001=MV001, '+
' LEFT JOIN WAY2006..CMSME ON ME001=MV004 '+
' ORDER BY ME002 ASC ');
' LEFT JOIN WAY2006..CMSMV ON MT001=MV001 '+
' LEFT JOIN WAY2006..CMSME ON ME001=MV004 '+
' ORDER BY ME002 ASC ');
' LEFT JOIN WAY2006..CMSMV ON MT001=MV001 '+
' LEFT JOIN WAY2006..CMSME ON ME001=MV004 '+
' ORDER BY ME002 ASC ');
'LEFT JOIN WAY2006..CMSMV ON MT001=MV001,'+
'LEFT JOIN WAY2006..CMSME ON ME001=MV004,'+
'ORDER BY ME002 ASC');
open 把里面的逗号去掉撒