I oversimplified my example query. I need to be able to also include 'non-unique' columns. This is probably a better example:

SELECT Case_Table.Case_Number, Note_Table.Note_Type, Note_Table.Date_Entered AS 'Date_Entered'

FROM Case_Table

INNER JOIN...