Skip to Content
Jan 06, 2013 at 01:25 PM

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



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?