mysql select id not in another table using join

steamboatid answered on January 27, 2023 Popularity 2/10 Helpfulness 1/10

answer mysql select id not in another table using join

Comment

SELECT  a.*
FROM    table1 a
            LEFT JOIN table2 b
                on a.ID = b.ID
WHERE   b.id IS NULL

Popularity 2/10 Helpfulness 1/10 Language sql

Tags: join mysql select sql using

Link to this answer
Share Copy Link

Contributed on Jan 27 2023

steamboatid

0 Answers Avg Quality 2/10

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