Dun & Bradstreet interview question

How would you handle an SQL join today?