select a value where it doesnt exist in another table in SQL Server? -

I have two tables - how can I get more information such as names and gender?

  @ A ID name gender ..... 1 A2B3C5D6E @ B ID POSID 3 1 5 2

I Use this SQL for query.

  Selection ID from a challenge ID select ID;

I found the result.

  ID 1 2 6

post-text" itemprop = "text"> < Try using

does not exist :

  select * where not exists (selection 1b to WHERE a.id = b.id) ; Use

or left external participant . Or not in .

LAva