ServiceNow Interview Question

Use SQL to join two tables with some trickery