perform an inner join and join based " on a.field = b.field" however interviewer didn't know that was possible and used the where clause to join tables which can result in messy filtering.