"How to get all ip_id of TABLE B Not present in Table A"

Question

TABLE A
===========
e_id    rid

160972  906913

160972  906915

160973  906924

160973  2258655

160973  2258656

160973  2258657

160973  2258658

TABLE B
==========
nid     ip_id

160972  906916

160973  2258657

How do i get all the ip_id of table B not present in table A in mysql ? Get the nid of table B whose ip_id is not present in table A.

Expected Result
---------------
nid     ip_id

160972   NULL

https://stackoverflow.com/questions/1519272/mysql-not-in-query — M. Suleiman, Nov 04 '19 at 04:52
I don't understand what such wilfully complex examples achieve. — Strawberry, Nov 04 '19 at 08:23

Roy Bogado · Answer 1 · 2019-11-08T07:02:40.960

0

Using NOT IN

The IN operator allows you to determine if a specified value matches any value in a set of values or returned by a subquery.

SELECT nid, id_id FROM TABLE_B WHERE ip_id NOT IN (SELECT rid FROM TABLE_A)

edited Nov 08 '19 at 07:02

answered Nov 04 '19 at 13:36

Roy Bogado

4,299
1
15
31

"How to get all ip_id of TABLE B Not present in Table A"

1 Answers1