SQL语句，限制表中某项相同参数的显示条数

select * from tablename b where

(select count(1) from tablename a where a.字段1<=b.字段1 and a.字段2=b.字段2)>2

SQL SERVER肯定行，但ACCESS可以试试。

双表用(SELECT * FROM TABLE1,TABLE2 WHERE TABLE1.ID=TABLE2.ID) 替换所有tablename就行了。

select * from booka where biaoti in (select biaoti from xinwentongzhi where id=".$id )

希望对你有帮助

---