Simple question that I can't find an answer to.
I am validating Data Studio (admin version) for use at our site. Most of it looks OK apart from trying to use the wizard to build row value SQL expressions such as
Update cmf a set (cftlvl,cfplvl) =
(select cftlvl,cfplvl from fixes b where a.cffac=b.cffac and a.cfcset=b.cfcset and a.cfcbkt=b.cfcbkt and a.cfprod=b.cfprod)
where (a.cffac,a.cfcset,a.cfcbkt,a.cfprod) in (select cffac,cfcset,cfcbkt,cfprod from fixes)
The code runs fine but the wizard will not build the 'IN' clause properly. It will not accept a list of values in the predicate.
I can't find any documentation, anyone know if this is possible.