有两个表,表1名为tb1,有如下字段:
name varchar(10)
size integer
表2名为tb2,有下面字段:
user varchar(20)
totall integer用SQL语句查询:查询表1中size大于表2中totall平均值的数据
name varchar(10)
size integer
表2名为tb2,有下面字段:
user varchar(20)
totall integer用SQL语句查询:查询表1中size大于表2中totall平均值的数据
调试欢乐多
应该是select tb1.name,tb1.size from tb1 where t1.size> select avg(tb2.totall) from tb2;
ADOQuery1.SQL.Clear;
ADOQuery1.SQL.Add('select * from 1,2 where 1.size>2.total1');
ADOQuery1.Open;
from tb1
where size> select avg(totall) from tb1,tb2;
select *
from 表1
where size>
(select avg(totall) from 表2)