我不知道我看明白没有, 好象应该换成:select dwxx.dddd,glyl.ffff from dwxx,glyl where dwxx.name=glyl.name order by glyl.ffff desc
刚才着急忘了! adoquery1.select('select dwxx.dddd,glyl.ffff from dwxx,glyl where dwxx.name=glyl.name order by glyl.ffff desc');
我不知道看明白没有,好象应该写成; select dwxx.dddd,glyl.ffff from dwxx,glyl where wxx.name=glyl.name order by glyl.ffff desc'
什么意思?TADOQuery没有一个select方法呀!? 是不是这个意思: adoquery1.SQL.Clear; adoquery1.SQL.Add('select dwxx.dddd,glyl.ffff from dwxx,glyl where dwxx.name=glyl.name order by glyl.ffff desc'); adoquery1.Open;
不知道你写些什么,你如下试试,可能能达到你的要求。 ADOQuery1.SQL.Text:='select dwxx.dddd,glyl.ffff from dwxx,glyl where dwxx.name=glyl.name order by glyl.ffff desc';
好象应该换成:select dwxx.dddd,glyl.ffff from dwxx,glyl where dwxx.name=glyl.name order by glyl.ffff desc
adoquery1.select('select dwxx.dddd,glyl.ffff from dwxx,glyl where dwxx.name=glyl.name order by glyl.ffff desc');
select dwxx.dddd,glyl.ffff from dwxx,glyl where wxx.name=glyl.name order by glyl.ffff desc'
是不是这个意思:
adoquery1.SQL.Clear;
adoquery1.SQL.Add('select dwxx.dddd,glyl.ffff from dwxx,glyl where dwxx.name=glyl.name order by glyl.ffff desc');
adoquery1.Open;
ADOQuery1.SQL.Text:='select dwxx.dddd,glyl.ffff from dwxx,glyl where dwxx.name=glyl.name order by glyl.ffff desc';