2 Replies Latest reply on Feb 4, 2008 11:30 AM by Exmachin4

    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?