Expand|Select|Wrap|Line Numbers
- SELECT
- PDB.PHONENUMBER,
- PD.TEMP_VAR2
- FROM
- db_sub_warehouse_b pdb
- JOIN db_sub_warehouse pd ON pdb.subwarehouse_id = pd.subwarehouse_id
- JOIN pd_reportex_b prb ON prb.iccid >= rtrim( pdb.temp_var1 )
- AND prb.iccid <= rtrim( pdb.temp_var2 )'
- WHERE
- 1 = 1
- AND pd.billcode = 'SW201904160006'