Converting SQL Statement for use in Designer

Hi,

I am having issues with a SQL statement that I generally run via Microsoft SQL Server. When I put the SQL into the designer I am getting an error. It does not like the a. b. c. reference. I was wondering if anyone knows how I should write this to pull data?

select a*
from dim_customer_account a,
dim_territory b,
dim_territory c
where a.current_primary_territory_sk = b.territory_sk /* for primary rep assignment*/
and a.current_secondary_territory_sk = c.territory_sk /* for secondary rep assignment*/

Thanks

Datasets

Accepted answers

gabrielvilella

Don't you need the AS, like:

SELECT column-name FROM table-name AS alias-name

All comments

gabrielvilella

Don't you need the AS, like:

SELECT column-name FROM table-name AS alias-name

CherylWalsh71

Thank you. I will try that.

CherylWalsh71

Hi Gabrielvilella,

I have tried this a few times but have still been unsuccessful. Any other ideas?

gabrielvilella

May be SQL code is not correct. You are selecting from three different tables, with no join. Not sure if this is possible.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703