David Robertson
Reputable Poster
I am trying to create a Business View over 4 tables, and a particular data selection to drive a UBE.
The problem I am having is to create the equivalent of brackets ( ) around an "OR" clause within the select statement. I can create the equivalent SQL easily enough, but cannot replicate the data selection in OW. Without being able to do this, the selection criteria becomes extremely long and unwieldy.
Does anyone have any ideas how to get around this limitation?
An example format of the SQL command is as follows:
select * from F03012, F550301, F0006, F0101
where AICO=CCCO and AIAN8=ABAN8 and ABMCU=MCMCU and CCCO=MCCO
and (CCMCU='*' or CCMCU=MCMCU)
and (CCRP24='*' or CCRP24=MCRP24)
and (CCRP25='*' or CCRP25=MCRP25)
and (CCRP26='*' or CCRP26=MCRP26)
and (CCRP27='*' or CCRP27=MCRP27)
order by AICO, CCRP27, CCRP26, CCRP25, CCRP24
The problem I am having is to create the equivalent of brackets ( ) around an "OR" clause within the select statement. I can create the equivalent SQL easily enough, but cannot replicate the data selection in OW. Without being able to do this, the selection criteria becomes extremely long and unwieldy.
Does anyone have any ideas how to get around this limitation?
An example format of the SQL command is as follows:
select * from F03012, F550301, F0006, F0101
where AICO=CCCO and AIAN8=ABAN8 and ABMCU=MCMCU and CCCO=MCCO
and (CCMCU='*' or CCMCU=MCMCU)
and (CCRP24='*' or CCRP24=MCRP24)
and (CCRP25='*' or CCRP25=MCRP25)
and (CCRP26='*' or CCRP26=MCRP26)
and (CCRP27='*' or CCRP27=MCRP27)
order by AICO, CCRP27, CCRP26, CCRP25, CCRP24