How do I turn a single query result into a Category/Products listing?

I have a custom query that JOINs various tables of data and outputs between 1500 and 3000 lines. In a very simplified example, this is what the query outputs…

┌──────┬───────┬───────────────────────┬─────────────────┐
│ line │ co_id │        co_name        │     contact     │
├──────┼───────┼───────────────────────┼─────────────────┤
│    1 │     1 │ A.B.C Repairs         │ John Stevens    │
│    2 │     1 │ A.B.C Repairs         │ Fred Truss      │
│    3 │     2 │ Grove Bodyworks       │ James Archibald │
│    4 │     2 │ Grove Bodyworks       │ Jean Bryers     │
│    5 │     2 │ Grove Bodyworks       │ Tony Flynn      │
│    6 │     3 │ High Street Car Paint │ Peter Ahmed     │
│    7 │     3 │ High Street Car Paint │ Kash Ahmed      │
│    8 │     4 │ London Repair Shop    │ Peter Jones     │
│    9 │     4 │ London Repair Shop    │ Robert Jones    │
│   10 │     4 │ London Repair Shop    │ Heath Probert   │
│   11 │     5 │ Newport ARC           │ Steve Abraham   │
└──────┴───────┴───────────────────────┴─────────────────┘

My problem, and I am sure there is a very simple answer, is that I want the result to be printed to screen like this…

A.B.C Repairs	
	John Stevens
	Fred Truss
Grove Bodyworks	
	James Archibald
	Jean Bryers
	Tony Flynn
High Street Car Paint	
	Peter Ahmed
	Kash Ahmed
London Repair Shop	
	Peter Jones
	Robert Jones
	Heath Probert
Newport ARC	
	Steve Abraham

So the Company Name is like a Category and the Contacts are like Products. I just can’t get my head around how to set-up the Server Connect and the Repeat properties to get this result, can you throw some light on it?

Community Page
Last updated: