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

5 votes160 views3 answers
Db begintransaction laravel
SQL
1 vote170 views1 answer
Apex run 404
SQL
0 vote131 views2 answers
Default constraint in ms sql
SQL
3 votes163 views2 answers
How to list columns for particular tables in postgresql
SQL
44 votes209 views6 answers
Rename command in sql
SQL
0 vote164 views1 answer
SQL Query Orderby Two or More Columns and by number of characters
SQL
2 votes180 views1 answer
Oracle block
SQL
0 vote121 views1 answer
Mysql regex exact match
SQL
1 vote144 views5 answers
What is in operator in sql
SQL
31 votes142 views2 answers
Grant all priviledges to mysql user
SQL