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

2 votes344 views1 answer
Oracle cpu per session
SQL
0 vote368 views1 answer
Sql use with to get value counts and percentages
SQL
4 votes348 views1 answer
What are the data types in sql
SQL
3 votes395 views2 answers
Sql not contains
SQL
9 votes359 views4 answers
How to create new user and database postgresql in ubuntu
SQL
2 votes384 views1 answer
Q operator in plsql
SQL
0 vote344 views1 answer
Postgresql add not null and not empty constraint
SQL
1 vote384 views1 answer
Update substring in mysql
SQL
0 vote358 views1 answer
Mysql two joins
SQL
0 vote368 views1 answer
Query params sql insert python f string
SQL