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

show blank in column if condition not matches in join mysql

Ankur answered on May 27, 2022 Popularity 1/10 Helpfulness 1/10

answer show blank in column if condition not matches in join mysql

show blank in column if condition not matches in join mysql

Comment

Use a LEFT JOIN

SELECT b.id, a.T1
FROM (query1) AS a
LEFT JOIN (query2) AS b ON a.id = b.id

LEFT JOIN means that the result should include all rows from the first table. If there's no match in the second table, all those columns (e.g. b.id) will be NULL in the result, but it will still show the columns from the first table.
You can slao use RIGHT JOIN, which reverses the roles of the first and second tables.

Popularity 1/10 Helpfulness 1/10 Language sql

Source: stackoverflow.com

Tags: join mysql show sql

Link to this answer
Share Copy Link