sql 问题
$sql= " SELECT TF.SLIP_I_NO AS SLIP_I_NO , TF.SENDER_CITY AS SENDER_CITY , C.ORDER_NO AS ORDER_NO".
" FROM TF_SLIP_TRANS_DATA TF ,TCLAIMDT C ".
" WHERE TF.SLIP_I_NO = C.ORDER_NO||C.ORDER_G_SEQ||C.ORDER_D_SEQ||C.ORDER_W_SEQ ".
" AND C.CLAIM_GB IN ('30','45') AND C.DO_FLAG='50' AND TF.DELY_GB = '13' ";
$n=$DB->ExecSQL( $sql );
while( $DB->Fetch() ) {
$SLIP_I_NO=$DB->Load_Field( "SLIP_I_NO" ); //取退编
$SENDER_CITY=$DB->Load_Field( "SENDER_CITY" ); //取城市
$ORDER_NO=$DB->Load_Field( "ORDER_NO" ); //取城市
$BILL_SLIP_I_NO = $SLIP_I_NO ;
$SQL="SELECT SLIP_I_NO FROM TSLIPDT ".
" WHERE ORDER_NO =$ORDER_NO ".
" AND ORDER_G_SEQ =001 ".
" AND ORDER_D_SEQ =001 ".
" AND ORDER_W_SEQ =001 ";
echo $SQL ;
$n=$DB->ExecSQL( $SQL );
$DB->Fetch() ;
$BILL_SLIP_I_NO=$DB->Load_Field( "SLIP_I_NO" );
echo "$BILL_SLIP_I_NO\n" ;
}
---
遇到一个奇怪问题。 两层sql语句 ,第一层sql查询可以查出3笔数据,也就是while()执行三次。但如果在while()中在嵌套写查询语句。最外层的就只执行一次,就不往下执行了。