which two join options can be used in the blank in the above query to get the requried output