In addition to using standard query functionality, there are three keywords that let you compare an expression value to a one-column subselect statement result set.