Emergent Software Interview Question

Use SQL to merge 2 tables together and isolate 3 columns of information based on a given task.