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
0
SELECT
thought.*
, verse.verse
FROM
verse
LEFT JOIN thought
ON (verse.`id` = thought.`id`);
#1
0
SELECT
thought.*
, verse.verse
FROM
verse
LEFT JOIN thought
ON (verse.`id` = thought.`id`);