DB02

1、DB02里面 不同长度的表字段inner join 

SELECT B.VBELN,
   A.KSCHL FROM NAST AS A
INNER JOIN VBRK AS B ON RIGHT( A.OBJKY,10 ) =  B.VBELN
WHERE  ( B.VKORG BETWEEN 'A101' AND  'A103' )
  AND  A.KSCHL = 'ZGPB' 

 

 

　　

 

UPDATE 表数据得SQL编辑器