Error while retrieving joining SQL views

I want join view ECO_REQUEST in any of the appropriate view in entity ManufStructAlternate. 

You don’t need to have the same number of columns to join two tables, but you need some sort of relationship between the two. Can you elaborate more on what you are trying to achieve here ? 

I want do display column from view ECO_REQUEST in any of the appropriate views in entity ManufStructAlternate, but  ECO_REQUEST dont share same column in any of the appropriate views in this entity. 

More information is needed - as @Trewon indicated, can you tell the forum how the data in ECO_REQUEST is related to ManufStructAlternate?  That is, how is a record from ECO_REQUEST going to be “matched up” to a correlating ManufStructAlternate record?

@Ed22 - more info needed for sure - BUT - you may be able to use an API call to ECO_REQUEST_API.GET_XXX(a,b,c)

to grab the field you need from the eco_request view where XXX is the name of the field and a, b and c are field names required to populate the get (this is assuming there is an eco_request_api).

Otherwise, you’ll probably need to find an additional view which allows you to make the link from ECO_REQUEST to the manufStructAlternate

If you can provide more detail of where the data you are trying to link is shown in the IFS client that will help the community to give you better advice.