开发者

query to obtain the missing content between two tables

开发者_JAVA技巧

I have two tables table A and Table B , i have used primary key of the table A as a Reference in table B , i need help to write a query to obtain the content that is present only in table A but missing in table b.

thanks in advance


SELECT * FROM tbl_a
LEFT JOIN tbl_b ON tbl_b.a_id = tbl_a.id
WHERE tbl_b.id IS NULL
0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜