[Closed] question belongs to Framework Manager. self join

[Srik]

In myÃ,  requirement 2 fields refer to same Columns (shortname) in database table .

can any tell me how to map same column to different fields?

Mapping for field is

Services --> program --> category(shortname)Ã,  : Activity
Services --> program --> category(shortname)Ã,  : Sub activity

Create alias for  program and category tables and join alias program table to program and Alias category to alias table of program table
or you can do it by creating shortcut for programs and category.

[BIsrik]

i am not clear with ur problem. Is that u want to join the different tables with same column, or u want to rename the same columns with two names..

If i am correct i feel you wanna rename the same columns with two names. then edit the sql of the table and then

add services.program.category as sub activity in the select clause.

Plz clarify

Srik

[Srik]

thanks srik for your info.

I got the logic .

Thank you,
Kanth

[BIsrik]

share the logic and update the topic..

Srik

[chennaiv2000]

thanks srik for your info.

I got the logic .

Thank you,
Kanth

k