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

Home
SQL Server
Write a query to fetch values in table test_a that are an
narasiman rao
narasiman rao
1k403416.7k
Write a query to fetch values in table test_a that are an
May 31 2017 2:41 AM
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