Salesforce Asked on January 10, 2021
As the title suggests, if I try and write a query like:
SELECT *
FROM TableA
LEFT JOIN TableB
ON TableA.Field = TableB.Field
I get an error saying
An error occurred while checking the query syntax. Errors: ‘SELECT * ‘ is not allowed if you use JOINs. Please specify all the column names you want to select
I know this can be done in SQL. Is this a marketing cloud limitation? Is there another way around this without having to type out every column in the query?
Yes, you are NOT allowed to use * while using joins in SFMC SQL activity.
And to answer your second question, YES there is a easy way of doing this.
You can just DRAG n DROP the DataExtension in the place of *
Please find the below illustration video link below. https://i.imgur.com/A7eicPz.gif
Correct answer by Vishal Kumar C V on January 10, 2021
Get help from others!
Recent Answers
Recent Questions
© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP