Skip to Content
0
Former Member
Feb 18, 2011 at 12:02 AM

record missed in a SQL

30 Views

hi experts

I run a SQL like :

SELECT UC_POD_EXT

UC_DATEFRO

UC_DATETO

/BIC/ZKWH_MR

/BIC/ZKWH_BILL

/BIC/ZBI_MRCON

FROM /BIC/AZFC_D9900 INTO TABLE LT_BILL

FOR ALL ENTRIES IN SOURCE_PACKAGE

WHERE UC_POD_EXT = SOURCE_PACKAGE-UC_POD_EXT.

SOURCE_PACKAGE only has 1 record, and this reocrd's UC_POD_EXT is 10032789420750421. and it return 31 records.

and I test another SQL like

SELECT UC_POD_EXT

UC_DATEFRO

UC_DATETO

/BIC/ZKWH_MR

/BIC/ZKWH_BILL

/BIC/ZBI_MRCON

FROM /BIC/AZFC_D9900 INTO

corresponding fields of TABLE LT_BILL

WHERE UC_POD_EXT = '10032789420750421'.

it return 34 reocrds

so some records missed in the first SQL, i don't know why.