在Laravel 4中加入两张桌子

I have two tables verse and thought. Im using Laravel 4.2 display the verses it is not listed in thoughts

我有两节经文和想法。我使用Laravel 4.2显示它没有列在思想中的经文

my want the output sample1 and sample 2

我想要输出sample1和样本2

1 个解决方案

#1

SELECT
thought.*
, verse.verse
FROM
verse
LEFT JOIN thought 
ON (verse.`id` = thought.`id`);