devxlogo

SQL Trouble

SQL Trouble

Question:
I keep getting a syntax error on the last part of this statement:

"SELECT DISTINCT [Company Name],  [Street Address] FROM " & d & "  WHERE[Street Address] !="

Maybe I am using the wrong syntax, but how do I also get distinct addresses when this database has duplicate names and addresses, and some with duplicate names and different addresses?

Answer:
The syntax error in this SQL statement is most likely the missing “!=” condition. You must specify what the [Street Address] column is not equal to. If I understand your situation, you could have duplicate address and duplicate names so you could create a subquery that first gets distinct addresses and then gets distinct names from that subset of records like this:

SELECT DISTINCT [Company Name] FROM TEST WHERE [Street Address] IN   (SELECT DISTINCT [Street Address] FROM TEST) 

See also  The Importance of Data Security in Hospitality
devxblackblue

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist