I got syntax error in my Select Distinct statement
Posted on 2008-10-16
Hi, I'm selecting a bunch of fields from a few tables in a single select statement. Here I want to select from table A with unique email adrress. However, I'm getting a syntax error. How can I resolve this error?
Also, I wan to make sure I select the record in table A where the id column has the lowest number in the event that there is duplicate records with the same email address.
SELECT [id], DISTINCT[email], [col1], [col2], [col3]