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

1 vote247 views1 answer
Sql oracle update multiple rows
SQL
0 vote169 views1 answer
Learn sqlite dart
SQL
0 vote198 views2 answers
How to see table associated with a schema in sql
SQL
11 votes212 views2 answers
Import sql file laravel cmd
SQL
1 vote168 views1 answer
Importance of comment in mysql
SQL
0 vote177 views2 answers
Oracle create chain rule
SQL
0 vote186 views2 answers
How to use aggregate functions in sql
SQL
1 vote181 views1 answer
Mysql list bigger table
SQL
0 vote283 views1 answer
Mysql failed to login as root@localhost
SQL
0 vote195 views1 answer
Sql put two columns into one
SQL