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 vote197 views3 answers
Database restoring error
SQL
0 vote157 views1 answer
Online sql compiler
SQL
2 votes189 views1 answer
Sql count having
SQL
0 vote206 views2 answers
Postgresql change user role grant
SQL
0 vote183 views1 answer
Mysql to get column name in database
SQL
17 votes261 views4 answers
Show all tables in oracle
SQL
0 vote213 views1 answer
Mysql grant all on all databases
SQL
0 vote196 views1 answer
Many rows to 1 string mysql
SQL
3 votes180 views1 answer
Pl sql check if variable is empty
SQL
17 votes201 views6 answers
Get last record in sql
SQL