select b.Id,b.TypeId,c.TypeName from tableB b,tableC c where c.TypeId=b.TypeId
select b.Id,b.TypeId,c.TypeName from tableB b,tableC c where c.TypeId=b.TypeId and c.TypeName like '类型%'
select b.Id,b.TypeId,c.TypeName from tableB b INNER JOIN tableC c ON b.TypeId=c.TypeId where c.TypeName like '%类型%'
假如在你的sql语句中的select后面加上count(*),那么这个sql语句应该怎么写?
假如在你的sql语句中的select后面加上count(*),那么这个sql语句应该怎么写?试试这个: select b.Id,b.TypeId,c.TypeName,COUNT(*) from tableB b INNER JOIN tableC c ON b.TypeId=c.TypeId where c.TypeName like '%类型%' group by b.Id,b.TypeId,c.TypeName
where c.TypeId=b.TypeId and c.TypeName like '类型%'
select b.Id,b.TypeId,c.TypeName
from tableB b
INNER JOIN tableC c
ON b.TypeId=c.TypeId
where c.TypeName like '%类型%'
select b.Id,b.TypeId,c.TypeName,COUNT(*)
from tableB b
INNER JOIN tableC c
ON b.TypeId=c.TypeId
where c.TypeName like '%类型%'
group by b.Id,b.TypeId,c.TypeName