sql
Select * from lend_putout Left Join lend_apply On lend_putout.STRLENDAPPLYID = lend_apply.STRAPPLYID Left Join perfer_putout On lend_apply.STRPERFERCARD = perfer_putout.STRPERFERCARD Left Join perfer_apply On perfer_putout.STRPERFERAPPLYID = perfer_apply.STRAPPLYID Left Join office On perfer_apply.STROFFICEID = office.STROFFICEID where 1=1
这条语句我在ORACLE中试过了,不行!
我对ORACLE不熟悉啊,不知道它对SQL有什么要求,请高手帮我写一写吧,在此谢过!
问题点数:0、回复次数:1Top
1 楼zhouyouben(爱因斯坦)回复于 2004-09-03 14:02:47 得分 0
好像不错Top




