[color=blue] select * from wzfl wzfl1 left join wzfl wzfl2 on wzfl1.bh=wzfl2.fbh where wzfl1.ccdm like '00_'[/color]