下面语句是什么问题,急!
update T_search set Fields=b.Fields,SelectType=b.SelectType from T_search a,(select distinct fields,fieldsnames,selecttype from T_search where fields is not null) b where a.fieldsnames=b.fieldsnames;
这语句会报错:ORA-00933 命令未正确结束
语法我感决没错阿
用惯了sql server,刚学oracle
谢谢各位的解答!!!