1.如分别有A,B,C,D四张表,A,B,C,D关联在一起如:((A Inner join B By A.Id =B.AId) Inner join C By B.Id =C.BId)Inner join D By C.Id =D.CId Where 条件一 AND 条件二... ;
上面按照时间排序。从中获取第11条到第20条数据。sql语句应该怎么写?
MySQL:
select * from (select ... from ((A Inner join B By A.Id =B.AId) Inner join C By B.Id =C.BId)Inner join D By C.Id =D.CId Where 条件一 AND 条件二... ) as table LIMIT 11,10