Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

How to use 'help view'uFF1FHELP

Former Member

‎2010 Jun 24 4:35 AM

0 Likes
398

Dear guys：

I want to use 'help view' to connect tables with 'OUTER JOIN'. For example:With primary table 'SPFLI' and secondary 'SCARR'，with each has different airline code of 10 and 18. I want show all the 18 airlines even if they do not have any flight numbers. I have tried several times but it also use 'INNER JOIN' to connect each other

Dear guys：

I want to use 'help view' to connect tables with 'OUTER JOIN'. For example:With primary table 'SPFLI' and secondary 'SCARR'，with each has different airline code of 10 and 18. I want show all the 18 airlines even if they do not have any flight numbers. I have tried several times but it also use 'INNER JOIN' to connect each other

Reply
1 REPLY 1
Read only

gerd_rother
Active Participant

‎2010 Jun 24 9:25 AM

0 Likes
372

Hi,

You should use the 'Search help exit' to select the data for yourself from the database. Go into the search help maintenance screen and press F1 on field 'search help exit'; follow the links. There is actually a pretty good documentation.

Regards, Gerd Rother