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?