Simple Query Report Is Grouping
Running V 5.5.0 Build 5501
Created a New Query Report with the following SQL
SELECT aaauser.First_Name, sduser.status
FROM aaauser Left Join sduser On sduser.userID = aaauser.User_ID Order by 1
Why does this return groups? I expected a simple listing of each user name even if the name was stored 10 times. What I get is a BLUE group header for every name with the name in a detail section.
Created a New Query Report with the following SQL
SELECT aaauser.First_Name, sduser.status
FROM aaauser Left Join sduser On sduser.userID = aaauser.User_ID Order by 1
Why does this return groups? I expected a simple listing of each user name even if the name was stored 10 times. What I get is a BLUE group header for every name with the name in a detail section.