Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: SQL Server
Expertise: Beginner
Jun 4, 2000

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) 
DevX Pro
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date