Hi
IN below code i want only to get 1 record . I dont want to use Max
(Select "Location" from OLCT where "Code" = (Select Max("LocCode") from DPO1 where "DocEntry"=T0."DocEntry")) "Location"
Thanks