SQL右连接

显示右表MES_BATTERY_PACKAGE 的数据

左表MES_DATA_PACK_BOX

select  MES_DATA_PACK_BOX.work_order,  MES_DATA_PACK_BOX.BOX_NUMBER, C.PACKAGE_NO,C.barcode,MES_DATA_PACK_BOX.CREATE_DATE from MES_DATA_PACK_BOX  
right join(

select mes_data_pack_box_cell.BARCODE as PACKAGE_NO,B.barcode as barcode,mes_data_pack_box_cell.box_number  from mes_data_pack_box_cell right join (
select * FROM MES_BATTERY_PACKAGE
where barcode in( select A from AA where H = 'ysy666')
        ) B ON B.PACKAGE_NO = mes_data_pack_box_cell.BARCODE
        )C ON MES_DATA_PACK_BOX.BOX_NUMBER = C.box_number