Joins in Impromptu

[vaisag]

Hi,

I want to join a table having 2 foreign keys to same table. How can I join same table twice to the main table.

eg:
I have say one table name as :Maintable which contains fields
HSTNID
ASTNID
Revenue

I want to show station and not the id.So I want to join this table to Detail table which is STN.
Fields in STN tables ate Stnid and STNDESC
Now to show description I want to join Maintable to STN tables twice.
Please help me

 

[BruceReed]

Vaisaq
You will have to use Catalogs to create a new alias. This alias is just the same table, but referred by a differnt name. See the menu catalog, tables in Impromptu, then then joins.

To modify catalogs you need admistrator version of Impromptu.

Bruce

 

[BruceReed]

Vaisaq

Did you find your problem?

Bruce

 

[vaisag]

I found the answer, Thanks.