How to create a union request in ActiveRecord yii2

Question

here actually request

SELECT id, name_film, slug_film, created_at FROM `fl_film`) UNION (SELECT id, name_mfilm, slug_mfilm, created_at FROM `fl_mfilm`) UNION (SELECT id, name_serial, slug_serial, created_at FROM `fl_serial`) ORDER BY `created_at` DESC LIMIT 10

how to make it a request.

zabachok zabachok 755 3 7 · Accepted Answer · 2016-07-20T10:08:42

Probably through the findBySql method. Read more here: link to api

LAV45 LAV45 354 one 3 · Answer 2 · 2016-07-21T00:03:09

I would refuse UNION if I were you. It is not necessary to spread data on different tables which should be displayed in one list. I recommend to look towards PostgreSQL. And first, read about Inheriting tables in Postgresql . For my project I once chose Single Table Inheritance and have never regret it.

How to create a union request in ActiveRecord yii2

2 answers 2

More articles: