narasiman rao

narasiman rao

  • NA
  • 519
  • 767k

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

Answers (3)