请问下列的SQL语句有何不妥?应该如何写呢
Select Top 1 PictureID,Caption from Pictures where PictureID In(Select PictureID from PictureDetails) and AuditMark='1' and left(PictureID,2)='00' and Caption like '%" + Request.Params["cont"] + "%' or Contents like '%" + Request.Params["cont"] + "%' Group by Left(PictureID,6) order by AuditDate Desc
------------------------------------------------------------------
说明: 主表Pictures有字段PictureID,Caption,Contents,AuditMark,AuditDate....
子表PictureDetails有字段PictureID...它与主表的PictureID关联
PictureID共有12位长(VARCHAR),前6位表示所属分类,我的目的是要求取得这样的记录:对于PictureID前6位相同的记录,只需要最新的一条记录(即AuditDate Desc)
所以我用到了Top 1, 分组Group by Left(PictureID,6) ,排序order by AuditDate Desc,但执行时这个语句老是通不过,不知如何写才能满足我的要求.
谢谢!!!