select a1.a1_num,a1.a1_field2,a1.a1_field11,a7.a7_lot,a7.a7_date,sum(a7_count)
from a7,a1
where a1.a1_id=a7.a1_id and a1.a1_id in (select a1.a1_id,a1.a1_field11
//问题在这里 我要返回id结果集, select 后面如果不写"a1.a1_field11"这个字段的话 having语句又无法执行
from a1,a7
where a1.a1_id=a7.a1_id
group by a7.a1_id
having a1.a1_field11>sum(a7_count))
group by a7.a7_lot,a7.a1_id
order by a7.a1_Id;
//实在对不起 没分了 非常感谢您的回答
from a7,a1
where a1.a1_id=a7.a1_id and a1.a1_id in (select a1.a1_id,a1.a1_field11
//问题在这里 我要返回id结果集, select 后面如果不写"a1.a1_field11"这个字段的话 having语句又无法执行
from a1,a7
where a1.a1_id=a7.a1_id
group by a7.a1_id
having a1.a1_field11>sum(a7_count))
group by a7.a7_lot,a7.a1_id
order by a7.a1_Id;
//实在对不起 没分了 非常感谢您的回答
from a7,a1
where a1.a1_id=a7.a1_id
and a1.a1_id in
(select a1.a1_id
from a1,a7
where a1.a1_id=a7.a1_id
group by a1.a1_id
having min(a1.a1_field11) >sum(a7_count)
)
group by a7.a7_lot,a7.a1_id
order by a7.a1_Id; 或select a1.a1_num,a1.a1_field2,a1.a1_field11,a7.a7_lot,a7.a7_date,sum(a7_count)
from a7,a1
where a1.a1_id=a7.a1_id
and a1.a1_id in
(select distinct a1.a1_id
from (select a1.a1_id,a1.a1_field11
from a1,a7
where a1.a1_id=a7.a1_id
group by a1.a1_id,a1.a1_field11
having a1.a1_field11>sum(a7_count)
)
)
group by a7.a7_lot,a7.a1_id
order by a7.a1_Id;
from a7,a1
where a1.a1_id=a7.a1_id
and a1.a1_id in
(select a1.a1_id
from a1,a7
where a1.a1_id=a7.a1_id
group by a1.a1_id
having max(a1.a1_field11) >sum(a7_count)
)
group by a7.a7_lot,a7.a1_id
order by a7.a1_Id; 或select a1.a1_num,a1.a1_field2,a1.a1_field11,a7.a7_lot,a7.a7_date,sum(a7_count)
from a7,a1
where a1.a1_id=a7.a1_id
and a1.a1_id in
(select distinct a1.a1_id
from (select a1.a1_id,a1.a1_field11
from a1,a7
where a1.a1_id=a7.a1_id
group by a1.a1_id,a1.a1_field11
having a1.a1_field11>sum(a7_count)
)
)
group by a7.a7_lot,a7.a1_id
order by a7.a1_Id;
from a7,a1
where a1.a1_id=a7.a1_id
and a1.a1_id in
(select a1.a1_id
from a1,a7
where a1.a1_id=a7.a1_id
group by a1.a1_id
having max(a1.a1_field11) >sum(a7_count)
)
group by a7.a7_lot,a7.a1_id
order by a7.a1_Id; 或select a1.a1_num,a1.a1_field2,a1.a1_field11,a7.a7_lot,a7.a7_date,sum(a7_count)
from a7,a1
where a1.a1_id=a7.a1_id
and a1.a1_id in
(select distinct a1.a1_id
from (select a1.a1_id,a1.a1_field11
from a1,a7
where a1.a1_id=a7.a1_id
group by a1.a1_id,a1.a1_field11
having a1.a1_field11>sum(a7_count)
)
)
group by a7.a7_lot,a7.a1_id
order by a7.a1_Id;