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

12 votes116 views3 answers
Duplicate a column in sql
SQL
1 vote111 views1 answer
Sql upsert
SQL
0 vote117 views1 answer
Sort by last two number sql
SQL
1 vote136 views3 answers
SELECT * FROM
SQL
3 votes108 views1 answer
Mysql CURRENT_TIMESTAMP()
SQL
0 vote110 views1 answer
Psql check if value in array
SQL
0 vote113 views1 answer
Formatting code with SQL Developer
SQL
0 vote133 views2 answers
Drop tables from local table database postgres
SQL
20 votes126 views4 answers
Sql count if
SQL
11 votes121 views2 answers
Oracle saurce code
SQL