Mysql search multiple tables

SELECT
  users_first_name,
  users_last_name
FROM
  (
    (
      SELECT
        users.first_name AS users_first_name,
        users.last_name AS users_last_name
      FROM
        users
        INNER JOIN companies ON companies.id = users.company_id
      WHERE
        (
          users.last_name LIKE 'TERM%'
        )
    )
    UNION
      DISTINCT (
        SELECT
          users.first_name AS users_first_name,
          users.last_name AS users_last_name
        FROM
          users
          INNER JOIN companies ON companies.id = users.company_id
        WHERE
          (users.first_name LIKE 'TERM%')
      )
    UNION
      DISTINCT (
        SELECT
          users.first_name AS users_first_name,
          users.last_name AS users_last_name
        FROM
          users
          INNER JOIN companies ON companies.id = users.company_id
        WHERE
          (companies.name LIKE 'TERM%')
      )
  ) AS union1;

Source: gist.github.com

Similar codes

0 vote105 views1 answer
Oracle procedure chain step
SQL
1 vote97 views1 answer
Error code 1175 mysql fix
SQL
0 vote97 views1 answer
Min mysql
SQL
0 vote92 views1 answer
Sub blocks in sql
SQL
1 vote98 views1 answer
Oracle sql create view
SQL
11 votes101 views5 answers
How to install sqlite3 python
SQL
3 votes108 views2 answers
Syntax error or access violation: 1701 Cannot truncate a table referenced in a foreign key constraint
SQL
1 vote107 views1 answer
Select 2 rows in sql
SQL
0 vote94 views5 answers
Sql table intermédiaire
SQL
1 vote111 views1 answer
Change default maximum runtime mariadb from phpmyadmin
SQL