Hi,
Need a “single” SQL query to retrieve records. The SQL query can be a nested/correlated one.
Example:
Table name: table1
Keyfields: (scr,cdi,rax)
SELECT scr,cdi,rax,srow,srti,schg
FROM table1
WHERE rc_struct_flag='S' and tron=-1 and hostclli='MTRLPQQQ00T'
scr cdi rax srow...