Skip to main content
E
Exmachin4
Known Participant
February 1, 2008
Answered

Group by with inner join

  • February 1, 2008
  • 2 replies
  • 340 views
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?
This topic has been closed for replies.
Correct answer Dan_Bracuk
select distinct

2 replies

E
Exmachin4Author
Known Participant
February 4, 2008
Wow, never seen that before. Seems to work thanks.
D
Dan_BracukCorrect answer
Inspiring
February 1, 2008
select distinct
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices