M3 interview question

how to do a sql join