SQL Query Error: An error occurred while checking the query syntax. Errors: Error while processing square brackets

Question

I am writing a Query where I want to select subscribers from a list wit the values that are added through a form, however I get the following error: "An error occurred while checking the query syntax. Errors: Error while processing square brackets"

This is the Query:

Select
l.EmailAddress,
l.First_Name,
l.Last_Name,
l.Company,
l.Phone,
l.userIp,
l.disclaimerTerms,
l.timeStamp,
from [_ListSubscribers] l
where ListName = ‘Whitepaper_Download_Test'

I am not sure what I am doing wrong here. Does anyone know how to fix the error?

Answer 1

You had a ',' character after last column (l.timeStamp - it needs to be removed). I only use square brackets if there's a space in Data Extension name, otherwise they are not needed.

Select
l.EmailAddress,
l.First_Name,
l.Last_Name,
l.Company,
l.Phone,
l.userIp,
l.disclaimerTerms,
l.timeStamp
from _ListSubscribers l
where ListName = 'Whitepaper_Download_Test'

Answer 2

You got a wrong character in the where clause

where ListName = ‘Whitepaper_Download_Test'

Should be

where ListName = 'Whitepaper_Download_Test'

and after the l.timeStamp, should not be a comma.

==>

Select
l.EmailAddress,
l.First_Name,
l.Last_Name,
l.Company,
l.Phone,
l.userIp,
l.disclaimerTerms,
l.timeStamp
from [_ListSubscribers] l
where ListName = 'Whitepaper_Download_Test'

Let us assume you have the List Whitepaper_Download_Test and a dataextension B that has these fields: Email,First,Last,Comp,Phone,Ip,Terms,Time. (I changed to different fields that you get the point).

Select
l.EmailAddress AS Email,
l.First_Name AS First,
l.Last_Name AS Last,
l.Company AS Comp,
l.Phone AS Phone,
l.userIp AS Ip,
l.disclaimerTerms AS Terms,
l.timeStamp AS Time
from [_ListSubscribers] l
where ListName = 'Whitepaper_Download_Test'

Target Data Extension is B.

But i believe that doesnt fix your First_Name error. Are you sure it is in the List? Can you make a Screenshot of the Fields in that List(no values please)?

Just for reference: Here is the description of _ListSubscribers https://help.salesforce.com/articleView?id=mc_as_data_view_listsubscribers.htm&type=5