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.