sql note

select code.ccode_name,a.mb,code.ccode
from GL_accsum a
left join code on a.ccode=code.ccode and code.igrade=1
where
	a.iperiod=2 
	and(
		code.ccode_name like '%应收票据%'
	or	code.ccode_name like '%应收账款%'
	or	code.ccode_name like '%预付账款%'
	or	code.ccode_name like '%应收股利%'
	or	code.ccode_name like '%现金%'
	or	code.ccode_name like '%银行存款%'
	)

select code.ccode_name,a.mb,a.me,a.mc,code.ccode  
from GL_accsum a  
left join code on a.ccode=code.ccode and code.igrade=1  
where  
    a.iperiod=2   
    and(  
        code.ccode_name like '%金融资产%'  
    or  code.ccode_name like '%应收票据%'  
    or  code.ccode_name like '%应收账款%'    
    ) 

版权声明：本文为博主原创文章，未经博主允许不得转载。