CGI Interview Question

about SQL join