SELECT t.* FROM deviceloginfo t ,houses h where t.HouseId = h.ID
and h.HousePurpose = '企业用房' order by t.createDate desc;可以查询出来
但换成:
SELECT count(t.*) FROM deviceloginfo t ,houses h where t.HouseId = h.ID
and h.HousePurpose = '企业用房' order by t.createDate desc;却报错
这是什么原因啊