kshirabdhi
New User
Joined: 22 Nov 2007 Posts: 13 Location: Noida
|
|
|
|
I need to collect data from several tables.Below are the details about the fields in the tables –
RTRN_SHPMT table --> rtrn_shpmt_stst_nbr, return_typ_nbr, vnd_nbr, vnd_rtrn_prof_nbr
VNT_RTRN_PROF table --> vnd_nbr, ra_nbr
VENDOR table --> vnd_duns_nbr, vnd_nbr
ZL_CRC table --> zl_store_nbr, return_typ_nbr
CNTR table --> cntr_nbr, return_typ_nbr
I need the zl_store_nbr and cntr_nbr for ra_nbr=1234, vnd_duns_nbr= 3456, vnd_rtrn_prof_nbr=1234
and rtrn_shpmt_stst_nbr in (0,9Thanks in advance |
|