Comments
Sort by recent activity
I had this situation come up today where I used the "All Non-Aggregated Columns" after typing in the group by and did not add all of them to the group by. Here is my select (the one aggregated column pointed out): [image] [image] Here is the Group By it created: [image] It is missing quite a few columns. Some examples are a.model_number AS ModelNumber, a.manufacturer AS Manufacturer, c.description AS Category, pr.Room, pr.RoomType here is the SQP Prompt Version: [image] I tried refreshing suggestions and re-doing it and got the same results. Any idea what would cause this? Thanks! / comments
I had this situation come up today where I used the "All Non-Aggregated Columns" after typing in the group by and did not add all of them to the group by.Here is my select (the one aggregated colum...