求一个sql语句

Question

有三个表表car  字段   car_id   car_name carlb_id表carlb 字段 carlb_id carlb_name表carimg字段  carimg_id carimg_name car_id我传一个carlb_id 查出 car表的数据 但我想得到 根据car_id 查出carimg的记录总数 是一个数字的 并且放在一个表里 得到表 car_id car_name carlb_id carlb_name count(carimg)-记录数

Answer 1

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

Answer 2

--多多练习，相互提升
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
--刚没看清

Answer 3

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