How to get value from two tables in one query?

Question

PHP

There are two tables "company" - companies are stored there and "market" - stores are mainly stored in it, but companies are also present. These two tables have the same columns, but "market" has an additional "comp" column that separates stores and companies in it.
You only need to display companies from these tables. Those. everything that is in the "company" table, and from the "market" table, everything in the "comp" column = 1.

Answer 1

Make union of two requests.