刚出错 ,老是出错
sql 2000中的语句
select * from ac01 where aab001 in
(select aab001 from ab01 where cae503='8') and cac001<>'1' and cae229='1' and (cac004='张1' or cac004='任1' or cac004='捷') order by aab001在Delphi中该怎么写,谢谢。
sql 2000中的语句
select * from ac01 where aab001 in
(select aab001 from ab01 where cae503='8') and cac001<>'1' and cae229='1' and (cac004='张1' or cac004='任1' or cac004='捷') order by aab001在Delphi中该怎么写,谢谢。
' (select aab001 from ab01 where cae503=''8'') and '+
' cac001 <>''1'' and cae229=''1'' and '+
' (cac004=''张1'' or cac004=''任1'' or cac004=''捷'') order by aab001';
(select aab001 from ab01 where cae503='8') and cac001 <>'1' and cae229='1' and (cac004=''张1'' or cac004=''任1'' or cac004=''捷'') order by aab001
这样吧
str := 'select * from ac01 where aab001 in (select aab001 from ab01 where cae503='+QuotedStr('8')+') and cac001 <>'+QuotedStr('1')+' and cae229='+QuotedStr('1')+' and (cac004='+QuotedStr('张1')+' or cac004='+QuotedStr('任1')+' or cac004='+QuotedStr('捷')+') order by aab001';