ServiceNow interview question

Use SQL to join two tables with some trickery