In SQL Nested select statments

Question

if exists(select query)

 

if exisits(select query)

else

insert query of match recrods. 

else

 

insert query unmatched records