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 vote104 views1 answer
Sqlite closes value
SQL
0 vote101 views1 answer
Wincc 7.4 to sql stackoverflow
SQL
1 vote112 views1 answer
Postgresql contains
SQL
2 votes98 views1 answer
Oracle create directory
SQL
1 vote108 views1 answer
Oracle apex run 404
SQL
0 vote100 views1 answer
Set column width in sqlplus
SQL
5 votes117 views1 answer
Commentaire table oracle
SQL
12 votes118 views6 answers
Between in sql
SQL
0 vote61 views1 answer
How to connect sql server using ip address in c#
SQL
7 votes124 views3 answers
Sql server reset auto increment
SQL