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 vote305 views1 answer
Oracle show running job
SQL
0 vote323 views1 answer
MySql shutdown unexpectedly InnoDB: Mutexes and rw_locks use Windows interlocked functions InnoDB: Uses event mutexes
SQL
0 vote365 views1 answer
Sql server phone constraint
SQL
0 vote330 views1 answer
How change the field place in mysql
SQL
5 votes380 views3 answers
Create function in postgresql
SQL
1 vote302 views1 answer
Check message id sql server
SQL
2 votes324 views1 answer
Query any digits record
SQL
4 votes326 views3 answers
Rename table column postgresql
SQL
1 vote312 views1 answer
Oracle create index if not exists
SQL
0 vote292 views1 answer
Postgresql subquery
SQL