Dun & Bradstreet Interview Question

How would you handle an SQL join today?