I'm using Axcess and I need to write and SQL script that should bring me
unique names and everything on the same line.
I have table which has collomns Name, Phone, Email
when I write SELECT distinct TableName.Name
the result shows only the NAME, but I want to select disctinct only name but I want to see the related information that the name refers to.
For example if the the Name Mr. Ancek Anderson is unique I want to see all the information about Mr. Ancek Anderson.
how should I write the sql script?
thank you in advance.