根据物料号和收货物料凭证，查询对应的序列号
  

SELECT   b~sernr c~lbbsa 
 
            FROM ser03 AS a INNER JOIN objk AS b 
 
               ON a~obknr = b~obknr 
 
 inner join equi AS d  
 
 on  
 
     d~sernr = b~sernr 
 
   INNER JOIN eqbs AS c 
 
        ON d~equnr = c~equnr 
 
   WHERE a~mblnr = '5000028388' 
 
        and d~matnr = '000000000000052261'