MySQL Forums
Forum List  »  PHP

Re: If selection results in too many rows
Posted by: Vemsom Helst
Date: June 08, 2017 04:56AM

Yes one row per SALES_DOCUMENT and ITEM as that is the comp Key.
And the rule is that I want a sort of 'check' column for EU, US and E1. E.g.
SALES_DOCUMENT / ITEM / EU / US / E1
0000155 / 001 / x / x / x
0000155 / 002 / x / 0 / x
0000155 / 003 / x / X / 0

Im getting the values EU, US, E1 (field GEGRU) in the TABLE2. If there exist a MATNR in both TABLE1 and TABLE2 that has EU in TABLE2.GEGRU then that should be marked as a 'check' in the new table I create, e.g. like the example above this text. Sorry if Im not explaining very well.
Im sure there are more people who asked this on different sites but I couldnt find anything.

Options: ReplyQuote


Subject
Written By
Posted
Re: If selection results in too many rows
June 08, 2017 04:56AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.