Dla tabeli twp_news chcę pobrać jeden rekord z tabeli twp_news_images. Wykombinowałem tak:
SELECT * FROM twp_news AS news LEFT JOIN (SELECT * FROM twp_news_images LIMIT 1) AS imgs ON news.newsId = imgs.news_imagesNewsId;
SELECT * FROM twp_news AS news LEFT JOIN (SELECT * FROM twp_news_images LIMIT 1) AS imgs ON news.newsId = imgs.news_imagesNewsId;