[php] 2Tabellen, 1 Abfrage

[Dukel]

wie wärs mit

SELECT a.* , b.* FROM news a INNER JOIN auth_user b ON (
a.author=b.user_id AND $searchin LIKE '%$searchfor%') ORDER BY a.id DESC
LIMIT $start,$end