use left joins if image is not always existing for news_main record
SELECT news_main.title, category.name, news_img.image
FROM news_main
JOIN category ON category.id = news_main.category_id
LEFT JOIN news_img ON news_img.id_news = news_main.id
not sure how to translate that into eloquent but that's how i'd do it in SQL
Last updated
2 years ago.
Sign in to participate in this thread!
Laravel
Laravel News
Laracasts
Laravel Podcast