** Table 1 **
fld1 is 2A,
fld2 is 3,0 &
fld3 is 2A...
** Table2 ** fld1 is 7A and which is a combined result of fld1, fld2, fld3 from Table 1.....
My requirement is, I would like to join the above tables using any join method and would like to list the records from table1 where all fields in table 1 has a mandatory entry in table 2....
Means while checking how can convert or typecast the decimal with char....
How can I write an SQL/400 query for the above mentioned?
July 5, 2013 6:05 AM
July 5, 2013 12:01 PM