Breaking News: Grepper is joining You.com. Read the official announcement!

select multiple tables mysql

Add Answer

Terrible Tapir answered on June 19, 2020 Popularity 10/10 Helpfulness 1/10

answer select multiple tables mysql

related mysql view from multiple tables

related how to select multiple columns from different tables in mysql

related mysql search multiple tables

select multiple tables mysql

Comment

SELECT t1.dt2, t2.dt4, t2.dt5, t2.dt3 #get dt3 data from table2
FROM table1 t1, table2 t2 -- Doesn't need to have t1, or t2
WHERE t1.dt2 = 'asd' AND t2.dt4 = 'qax' AND t2.dt5 = 456

Popularity 10/10 Helpfulness 1/10 Language sql

Source: Grepper

Tags: multiple-tables mysql select sql

Link to this answer
Share Copy Link

Contributed on Sep 19 2021

Terrible Tapir

0 Answers Avg Quality 2/10

Closely Related Answers

mysql view from multiple tables

Comment

CREATE VIEW V AS (

  SELECT i.country,i.year,p.pop,f.food,i.income FROM
    INCOME i
  LEFT JOIN 
    POP p 
  ON
    i.country=p.country
  LEFT JOIN
    Food f
  ON 
    i.country=f.country
  WHERE 
    i.year=p.year
  AND
    i.year=f.year
);

Popularity 9/10 Helpfulness 3/10 Language sql

Source: stackoverflow.com

Tags: multiple-tables

Link to this answer
Share Copy Link

Contributed on Jun 19 2020

Clear Chamois

0 Answers Avg Quality 2/10

how to select multiple columns from different tables in mysql

Comment

-- MySQL 
-- t1 = table1
-- dt2 = column of table
SELECT t1.dt2, t2.dt4, t2.dt5, t2.dt3 #get dt3 data from table2
FROM table1 t1, table2 t2 -- Doesn't need to have t1, or t2
WHERE t1.dt2 = 'asd' AND t2.dt4 = 'qax' AND t2.dt5 = 456

Popularity 10/10 Helpfulness 3/10 Language sql

Source: stackoverflow.com

Tags: multiple-columns mult

Link to this answer
Share Copy Link

Contributed on Jul 22 2020

HmongsterMoua

0 Answers Avg Quality 2/10

mysql search multiple tables

Comment

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;

Popularity 8/10 Helpfulness 3/10 Language sql

Source: gist.github.com

Tags: multiple-tables

Link to this answer
Share Copy Link

Contributed on Oct 27 2021

steamboatid

0 Answers Avg Quality 2/10

select multiple tables mysql

Contents

More Related Answers

select multiple tables mysql

Closely Related Answers

mysql view from multiple tables

how to select multiple columns from different tables in mysql

mysql search multiple tables

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.