22,209
社区成员
发帖
与我相关
我的任务
分享
select
a.car_id,a.car_name,b.carlb_id,b.carlb_name,count(carimg_id) 记录数
into
newtable
from
car a,carlb b,carimg c
where
a.car_id=c.car_id and b.carlb_id=a.carlb_id and a.car_id=c.car_id
and
carlb_id=@carlb_id
group by
a.car_id,a.car_name,b.carlb_id,b.carlb_name
--多多练习,相互提升
select a.car_id,a.car_name,b.carlb_id,b.carlb_name,count(carimg_id) 记录数
into newtable
from car a,carlb b,carimg c
where a.car_id=c.car_id and b.carlb_id=a.carlb_id and a.car_id=c.car_id
group by a.car_id,a.car_name,b.carlb_id,b.carlb_name
--刚没看清
select a.car_id,a.car_name,b.carlb_id,b.carlb_name,count(carimg) 记录数 into newtable
from car a,carlb b
where a.car_id=c.car_id and b.carlb_id=a.carlb_id
group by a.car_id,a.car_name,b.carlb_id,b.carlb_name