bildwelt
E2E FORUM
E2E Bridge E2E Commerce

How can I select data with SQL UNION statements?

E2E Forum Modeling & Development How can I select data with SQL UNION statements?

This topic contains 0 replies, has 1 voice, and was last updated by  Jürgen 3 years, 8 months ago.

Viewing 1 post (of 1 total)
  • Author
    Posts
  • #803

    Jürgen
    Moderator

    If you have statements like:

    “select kunnr || ‘ ‘  || mandt  “myNumber” from customer
    union all

    select country_id “myNumber” from countries”

    you can use this statement as it is in the E2E Bridge SQLAdapter. You only have to make sure that the column names of the result set matching the attribute names of your result class in UML. In this case you would have to model a class with an attribute “myNumber”.

     

Viewing 1 post (of 1 total)

You must be logged in to reply to this topic.