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

Question

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?

Vishal Kumar C V · Accepted 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

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

One Answer

Add your own answers!

Ask a Question