问一下这个SQL那里错了

[my202com4]

String sqlQueryAll="select b.base_id,b.base_name,b.base_area,st.street_name,sn.strnum_name,d.dong_name,u.unit_name,l.layer_name,p.plate_name"
+"from base b,street st,strnum sn,dong d,unit u,layer l,plate p where "
+"b.street_id=st.street_id"
+"and b.strnum_id=sn.strnum_id"
+"and b.dong_id=d.dong_id"
+"and b.unit_id=u.unit_id"
+"and b.layer_id=l.layer_id"
+"and b.plate_id=p.plate_id"
+"and b.base_name like '%"+base_name+"%'"
+"and b.base_area like '%"+base_area+"%'"
+"and st.street_name like '%"+street_name+"%'"
+"and sn.strnum_name like '%"+strnum_name+"%'"
+"and d.dong_name like '%"+dong_name+"%'"
+"and u.unit_name like '%"+unit_name+"%'"
+"and l.layer_name like '%"+layer_name+"%'"
+"and p.plate_name like '%"+plate_name+"%'";

[my202com4]

java.sql.SQLException: ORA-00923: 未找到预期 FROM 关键字

[Rachael1001]

每一句都需要空格隔开
"select "
+" b.base_id,b.base_name,b.base_area,st.street_name,sn.strnum_name,"
+" d.dong_name,u.unit_name,l.layer_name,p.plate_name"
+" from base b,street st,strnum sn,dong d,unit u,layer l,plate p where "
+" b.street_id=st.street_id"
+" and b.strnum_id=sn.strnum_id"
+" and b.dong_id=d.dong_id"
+" and b.unit_id=u.unit_id"
+" and b.layer_id=l.layer_id"
+" and b.plate_id=p.plate_id"
+" and b.base_name like '%"+base_name+"%'"
+" and b.base_area like '%"+base_area+"%'"
+" and st.street_name like '%"+street_name+"%'"
+" and sn.strnum_name like '%"+strnum_name+"%'"
+" and d.dong_name like '%"+dong_name+"%'"
+" and u.unit_name like '%"+unit_name+"%'"
+" and l.layer_name like '%"+layer_name+"%'"
+" and p.plate_name like '%"+plate_name+"%'";

[DBA_DREAM]

楼上正确

[my202com4]

有空格啊

[my202com4]

哦谢谢,我试试