SQL: select B.NAME,B.DESCRIBE,B.IMG,B.URL from BFCRM8.WX_MENU A ,BFCRM8.WX_MENUITEM B WHERE A.DM=B.DM and NBDM='CYCRM_Z012' order by a.dm,inx