This being a tabular visualisation of SQL result sets you'd either have duplication in some columns or aggregated results. That's simply how SQL deals with 1:n

This being a tabular visualisation of SQL result sets you'd either have duplication in some columns or aggregated results. That's simply how SQL deals with 1:n and n:m relations.