I am joining two tables, applications and references, using an outer join on the first name and last name (see attached). The relationship between the two tables is one to many, i.e., for each record in the applications table, there can be zero to two records in the references table. I would like to obtain all the columns from the applications table and the title, first name and last name of the reference and their comments from the references table. Currently i am getting the output as two rows for the same applicant if they have two references, i.e., one row that has all the applicant's information, their first reference and the reference's comments, and another row that has the same applicant's information again with their second reference and their comments. I would like all the output to appear as a single row. What should I do to accomplish this?