[ad_1]
I am trying to pull a list of people from a specific database, that have opened any email with the email name 'Lorem' more than once. I have multiple emails with that email name and I want that group of people who have opened all of them. I am getting the following error:
An error occurred while checking the query syntax. Errors: SELECT is not a known data extension or system data view. You can only query existing data extensions or system data views. 'SELECT * ' is not allowed if you use JOINs. Please specify all the column names you want to select
SELECT *
FROM "TABLE_1"
WHERE
(
SELECT IsUnique
FROM [_Open]
WHERE Count > 2
JOIN
SELECT EmailName
FROM [_Job]
WHERE EmailName LIKE 'lorem'
)
[ad_2]
لینک منبع
