TransWikia.com

Marketing cloud not allowing the use of SELECT * when there is a join in the query

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?

One Answer

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

enter image description here

Correct answer by Vishal Kumar C V on January 10, 2021

Add your own answers!

Ask a Question

Get help from others!

© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP