Assuming the following stucture
table contract: contract\_id, status\_id, vendor\_id
table status: active (status\_id = 1), inactive (status\_id = 2), deleted (status\_id=3)
table vendor: vendor\_id, vendor\_name

How can I list only vendors with their contracts, all of them either inactive or deleted?
so if there is at least one contract for specific vendor which is active, this vendor and all of his contracts should be omitted

EDIT:
sample schema
<http://sqlfiddle.com/#!18/01f4c/5>