从嵌套的sql select中选择一条记录

Help - I have puzzeled on this for some time and am going bats. In this cutdown query I want to select a single Email address from a contacts list that may contain multiple contacts for that customer.Help - I have puzzeled on this for some time an