BAQ two table results

Do you just need one field from each of those tables? If so I have a cool trick for you. This is nice because it doesn’t puke if it can’t find one.