MySQL : How to query two tables sequentially?

Question

例如，
有两个表articles_1和articles_2，它们具有相同的字段:

id
title
content
slug

当有一个表时，我可以这样查询一篇文章:

public function show($slug)
{
    $article = Article::findOrFail($slug);

    return view('show', compact('article'));
}

现在有两个表，我想查询一篇文章，代码怎么写？

Answer 1

你可以使用 UNION

$table1_items = \DB::table('articles_1')
            ->select(\DB::raw("id, title, content,slug"))

$table2_items  = \DB::table('software_items')
            ->select(\DB::raw("id, title, content,slug"))

$results = $table1_items->union($table2_items)->get();