组合两个db表以在单个html表中显示

Question

I have a table for categories and a table for tags.

I can query and limit and paginate these fine, however what I really want to be able to do is combine these and then sort alphabetically as well as paginate.

It's not something i've done before, so I wonder if it's even possible using existing tools or I am going to have to write the query manually and add in the pagination etc.

$categories = DB::table('categories')->sortBy('Title')->paginate(20);

will work for that, but want them both, sorted by Title and paginating.

Possible?

Answer 1

SELECT column_name(s) FROM table1
UNION ALL
SELECT column_name(s) FROM table2;