How to create view with two code-descriptions from the same table

Former Member — Sun, 06 Jan 2013 13:25:39 GMT

Hi.

I have a table with 2 different code fields: city_from_code and city_to_code.

those 2 fields has the same check table - T5J63 which contains the city codes and the city names (code descriptions).

I want to create a view which base on my table and also on the table of those code descriptions (T5J63)

in order to display in the view the 2 codes but each code with his description.

when I create the view, it is not possible to choose twice the same description table (T5J63) in the relationships (once with join to city from and once with

join to city to).

how can I display in the view, the two descriptions?

thanks

Re: How to create view with two code-descriptions from the same table

Former Member — Mon, 07 Jan 2013 04:24:35 GMT

Hi Ami,

Create two different view then join these two view .

Example : 1st ABC table + T5J63 Table = > View 1 join to city from

2nd ABC table + T5J63 Table = > View 2 join to city to

Regard's

Smruti

topic Re: How to create view with two code-descriptions from the same table in Application Development and Automation Discussions

How to create view with two code-descriptions from the same table

Re: How to create view with two code-descriptions from the same table