Group by with inner join

[Exmachin4]

I'm running a query that grabs all the data the use selected but I only want it to show 1 of each.

Example1

Select the Activity you would like to match waste to.
Coating - Employee Training
Printshops - Spill Control
Printshops - Spill Control
Printshops - Spill Control

Example 2
Select the Activity you would like to match waste to.
Coating - Employee Training
Printshops - Spill Control

The current query shows example 1 and my boss wants example 2 shown any ideas?

[Dan_Bracuk · Accepted solution]

select distinct

[Exmachin4]

Wow, never seen that before. Seems to work thanks.