CGI interview question

about SQL join