You must Sign In to post a response.
  • Category: SQL Server

    Write a query to fetch values in table test a that are and not in test b without using the NOT keywo

    i have two table as follows

    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
  • #769248
    this might help you...

    select A.* from table_A A left join Table_B B on A.item=B.item where B.item is null


Sign In to post your comments