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 vote301 views1 answer
Python dictionary to sql update
SQL
0 vote262 views1 answer
VSCode SQL Server Connection error
SQL
0 vote262 views1 answer
Select count concat string sql server
SQL
0 vote214 views0 answer
How to connect to datbase in springboot
SQL
0 vote258 views1 answer
Mysql repair a table
SQL
0 vote255 views1 answer
Mssql now diff 90 day
SQL
0 vote285 views1 answer
Mysql 3 months ago
SQL
37 votes269 views5 answers
FIND DUPLICATES IN COLUMN SQL
SQL
0 vote217 views1 answer
Oracle list all stored procedures
SQL
1 vote225 views1 answer
Stored procedure return value
SQL