Query Builder - Display Distinct Rows Based On ID

[Fistful_Dollars]

How do I display only distinct accounts/IDs?  Right now the output pops out dozens of the same exact row, except certain columns have different dates.

[FredrikE · Accepted solution]

Just keep the ID column 🙂

Then use the resulting table to join with other data you need.

//Fredrik

[Fistful_Dollars]

Great, thank you FredrikE.  Worked very well.  I created another query(see below) to use only for joining.  There was another column ID I needed.  I used the MAX function for that column so there would be no repeat IDs from the first column, and because I only need the highest number for that variable.