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
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
for that how can i write the query in sql server