Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Reply from horacio zapettini on Apr 11 at 7:53 AM How long does it take to write that select and test it? Few minutes at most? Have you tried it?
My friend, I don't want to be unpolite, but... COME ON!!! you're asking if you can use a left outer join in a select? You can simply write a select with inner join into an internal table, then copy and paste that select and change the inner join with a left outer into a second internal table and once you have both, you can compare both results. Even better, you can discard the matches in both tables, and analyze a few of the remaining rows in both internal tables to get an idea of which one is wrong and which one is right. Once you're there, you have an answer.
All of this can be done in a simple report...
Questions like this are the reason why I've stopped posting answers at these groups. Where is the challenge? There used to be a time when we discussed about complex stuff (like performance issues, how to's, ...) . Toolbox used to be a place for pro's asking things they could not solve by their own and you used to ask only after you had tried everything.
Sorry GROUP, but I had to tell this...
| | | ---------------Original Message---------------
From: gold33
Sent: Thursday, April 11, 2013 1:09 AM
Subject: Can Left Outer Join Be Done in Mapping Table Situation?
Now I have three tables including TB01, MAPTB, SLTAB.
TB01 has Material, Plant, and Storage Location.
MAPTAB just for mapping, so no data I want to show in the selection screen
SLTAB has available volume.
And what I want is to show the Material NUM Plant S/L and the available volume.
TB01 and SLTAB has to map through MAPTAB by a colunmn (LGNUM) in MAPTAB.
So in this situation can I use the left outer join to do this or do you have any advice? |
| Reply to this email to post your response. __.____._ |   _.____.__ |
