Procedure Or Function?

Trying to get a handle on how to attack this problem of adding a new record in a table that has 2 joins to access (user) and associate with a grandparent table (hotel).

There is also a date condition with a separate table (contracts) in order to start the operation.

Select from Contracts where TermBegin and TermEnd <> today
For each contract hotel{
#Do they already have user?
Match User.ID + Organization.ID + Hotel.ID
If not{
Create Person
}

I'm not sure how to return the negative results of the 3 table join of User.Id + Organization.ID + Hotel.Id

Thanks for any tips/iedas