why when using the search form in grid, subquery is not running?
Could not execute query. ORA-00907: missing right parenthesis – SELECT count (*) as c FROM (SELECT 1 FROM LAP_X h as c "AND" substr (TGL, 0,4) = '2014' GROUP BY DATE) o
should not "AND" but "WHERE"
this my query
SELECT SUBSTR(TGL,5,2) AS TGLX,
substr(last_day(to_date(TGL,'rrrrMM')),-2) AS day,
( ( ( select sum(JUM) from lap_x d WHERE d.sat = 'XXX'
AND d.tgl= h.tgl) + ( select sum(JUM*62.744) from lap_x d WHERE d.sat= 'YYY'
AND d.tgl= h.tgl) )/1000) AS XXX
GROUP BY TGL
We are sorry that this post was not useful for you!
Let us improve this post!
Tell us how we can improve this post?