Write a query to fetch values in table test_a that are an

narasiman rao

9y1.9k

Write a query to fetch values in table test_a that are and not in test_b without using the NOT keyword

test a table as follows

test b table as follows

i want to write a query to fetch values in table test a that are and not in test b without using the NOT keyword

for that how can i write the query in sql server

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

narasiman rao9y ago
test a table as follows
id
10
20
30
40
50

test b table as follows
10
30
50

i want to write a query to fetch values in table test a that are and not in test b without using the NOT keyword

i tried the below query

Select id.* from test a
Left join test b on (testa.id = testb.id) where testb.id is null
whether the above one is correct ?
0
narasiman rao9y ago
Select id.* from test a
Left join test b on (testa.id = testb.id) where testb.id is null
whether the above one is correct. please let me know.
0
Praveen Kumar9y ago
Have you tried yourself first?

Please try to develop skills rather spoon feeding.
+1