Dear all,
i have situation here and really needs help on it.
I have to create one report.
since i need to grab data from two database so i create view command to select fields needed.
for example
so i create 2 select command here,
comand 1 will select
field a
field b
filed c
field d - multiple code from field e
comand 2 will select
field e -code
field f -description
the reason why i select this field with diff command because,
data in field d contain multiple data in field e in each row with seperated by ";".
so im using split function to split each of it, it works, but my problem start when im trying to do comparison from array created with code in field e to retrieve description in field f .
so can anyone guide me for better solution to do this.