微薄第一篇文章,却赶上星期六的最后五分钟、各种无语,只能简单写几句了。
LET l_sql = " SELECT distinct bmb02,bmb01,bmb03,bmb06 from bmb_file ",
" where bmb29 ='",g_bmb29,"' ",
" start with bmb01='",g_bma01,"' connect by prior bmb03=bmb01 "
递归写法很适用在BOM结构转下阶,条件用bmb03=bmb01 关键字connect by prior
下期再见哦......
最后欢迎大家加入易拓大家庭,一起学习进步!QQ群53145013