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 vote156 views1 answer
Sql random decimal
SQL
1 vote169 views1 answer
Pentaho + pasar de excel a sql
SQL
0 vote181 views1 answer
Import sql inside hide sql
SQL
2 votes177 views1 answer
ADD COLOUNS CREATED AND UPDATED AT IN MYSQL
SQL
0 vote180 views1 answer
Reindex mssql table
SQL
8 votes161 views3 answers
Mysql alter table add index
SQL
0 vote165 views1 answer
How to connect sqlalchemy to mysql and deploy it
SQL
0 vote169 views7 answers
10 random questions use python and SQL
SQL
0 vote166 views5 answers
Sql table intermédiaire
SQL
0 vote173 views1 answer
Sql query to force the database to be drop
SQL