Another Q. I need to joint two table together. It's one to multiple situation. I need to select one record based on some criteria, say for example, based on an effective day would be one to one, how could I do that?
Another one, I need to accept PARM from client input, I need to format the client input for example change the input to upper case so I can use it for selection criteria?
Another one, I need to accept PARM from client input, I need to format the client input for example change the input to upper case so I can use it for selection criteria?