SQL query Axcess

Dear Experts,
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
FROM TableName;
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.
LVL 1
BRMarketingAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
David H.H.LeeConnect With a Mentor Commented:
Hi Braveheartli,
Try this:
SELECT  TableName.Name, TableName.Phone, TableName.Email
FROM TableName where exists(SELECT distinct TA.Name FROM TableName AS TA where TA.Name= TableName.Name) 

Open in new window

0
 
BRMarketingAuthor Commented:
thank you x_com
What does TA mean?
0
 
David H.H.LeeCommented:
Hi Braveheartli,
TA mean alias or it is shorthand notation. You can declare it under different alias for each referred table and reuse it over your query easily. Beside that table alias also used to remove the ambiguity of the column names used in different tables especially if using in complex query.


0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.