SELECT a.*, b.lastrpdate, b.lastrpname, b.lastrptitle
FROM category a, artical b, (select max(lastrptitle) as lastrptitle,category from lastrptitle group by category) c
where a.category = b.category and b.lastrptitle = c.lastrptitle and a.category = c.category
FROM category a, artical b, (select max(lastrptitle) as lastrptitle,category from lastrptitle group by category) c
where a.category = b.category and b.lastrptitle = c.lastrptitle and a.category = c.category
introcategory, lastrpdate, lastrpname, lastrptitle
from artical ,category,(
SELECT max(a.articalID) as MaxArticalID, c.categoryID
FROM category c INNER JOIN
artical a ON a.category = c.categoryID
group by c.categoryID
) aaawhere aaa.MaxArticalID = artical.articalID and category.categoryID = aaa.categoryID