BR
asked on
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
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.
ASKER
What does TA mean?