Add join without any column from that table

[Former Member]

Hi All,

i have a query requirement like i dont want anything in select from that table but i need to alias the table and join to the original table and this need to be included in report query.

can anyone suggest how to do this,as this is a immediate change.

thanks in advance.

thanks,

sravya

[Former Member · Accepted solution]

Hi,

in IDT, you need to create a Where clause where you will add your alias table.

Anytime these objects are selected in the query panel the alias table will be added in the join but no column from that table in the Select statement.

Another way is to add the Alias table in the Associate dTables for each object that can be used in the query panel.

Didier

[jyothirmayee_s]

Hi Sravya,

What type of Table is it and where is it coming from?.

Copy that view and rename as an alias and start joining on common column.

Thanks,

Jothi

[Former Member]

Hi Jyothi,

if i dont select anything from that alias table will that join includes in query?

[jyothirmayee_s]

Yes Sravya,

If your query doesn't have alias table included with in the statement then no data is rendered from the table.

But any specific reason that you want an alias table and doesn't want data?. any scenario?.

Thanks,

Jothi

[Former Member]

Jyothi,

i think this works, if we pull an column form alias table into querypanel and final not adding it to the report will solve i guess

[jyothirmayee_s]

well, it depends.

Merging dimensions would help you to get equi join records, if not then it would be Cartesian product.

Thanks,

Jothi