I'm trying to get a query on several fields that are in 2 Data Extension Tables (the matching content is SubscriberKey). I'm familiar with SQL, but I used it primarily creating lists in Oracle's Responsys platform, and had several oddities and order requirements that required a specific methodology to query.
I followed the steps in https://help.marketingcloud.com/en/documentation/exacttarget/interactions/activities/query_activity/ to fit my query. Tried to do it as exact as possible in case formatting is fickle.
SELECT c.[User Status], b.[Points Used], a.[Status] as 'Subscription Status', a.[EmailAddress] as 'Email' FROM _subscribers a INNER JOIN _UserData Usage b _Website Information c ON a.Subscriber Key = b._SUBSCRIBERKEY = c._SUBSCRIBERKEY
However I get this error when checking the syntax: "_UserData is not a known data extension or system data view. You can only query existing data extensions or system data views."
These are user data lists from our online database. They are stored in a separate folder (not in the root...maybe that's the issue...).
Also, should each inner join be separated or can it be combined like I have it above?
Note: I'm trying to create a send-able list for active people with a certain amount of points to boost engagement of our most active. The data is on 2 different Extension Tables that I need to create a send Data Extension. Doesn't seem you can use Filters for 2 different data sets even when they have a linking, so my workaround is using SQL to pull the data and create a list.
The plan is to have all this data into 1 table, but that isn't ready for at least a month. Right now data is split into several Data Extensions.