回答編集履歴
1
Laravelの記述例も追加
answer
CHANGED
|
@@ -4,4 +4,12 @@
|
|
|
4
4
|
```SQL
|
|
5
5
|
Select * from articles left outer join article_admin on author = article_admin
|
|
6
6
|
where article_admin.id is not null
|
|
7
|
+
```
|
|
8
|
+
|
|
9
|
+
ちなみに、Laravelのleft joinの例です(すいません。未検証ですが)
|
|
10
|
+
```php
|
|
11
|
+
$articles = DB::table('articles')
|
|
12
|
+
->leftJoin('article_admin', 'articles.author ', '=', 'article_admin.article_admin')
|
|
13
|
+
->whereNotNull('article_admin.article_admin');
|
|
14
|
+
->get();
|
|
7
15
|
```
|