Skip to Content
author's profile photo Former Member
Former Member

search help from two tables for single field


I have two tables zmes_h and znpo_h , these two tables are having same field mes_num . now I want create a search help for this field but i need to get values from two tables. here field mes_num contains different values in two tables.

please give me the solution its an urgent

thanks in advance



Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Jan 18, 2008 at 07:29 AM


    create help view(se54)

    Help views can be used as selection method in Search help.

    Help view is created if a view with outer join is needed as selection method of a search help.

    Help views are used exclusively for search helps.

    A conventional database view selects data from the database using an inner join.

    For a help view however, data is selected using a left outer join.

    Eg-> Suppose table SCARR (Airline master table) has AA – American airlines

    AB – Air Berlin

    AC- Air Canada as three entries.

    Table SPFLI (Flight schedule) has entries corresponding only to airlines AA (American airlines) and AB (Air Berlin).

    Now if a database view were to be used as a selection method for a search help for airlines, we would only get AA and AB as possible entries because the database view implements an inner join…….If however, we were to use a help view as the selection method here, we would get AA,AB and AC as possible entries because a help view would implement a left outer join.

    Restrictions for Help Views

    There are some restrictions for selecting the secondary tables of a maintenance view or help view. The secondary tables have to be in an N:1 dependency to the primary table or directly preceding secondary table. This ensures that there is at most one dependent record in each of the secondary tables for a data record in the primary table.

    Go thru this link plzz



    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.