Oracle APEX (Advanced) - Highlight row based on condition
I have this query on a classic report
SELECT w.vendor, w.qty, r.rec
FROM (SELECT vendor, SUM(ord) AS qty
FROM wag where ship_date = :P0_DATE
GROUP BY vendor) w,
(SELECT vendor, SUM(ord) AS rec
FROM recinc where "sDATE" = :P0_DATE
GROUP BY vendor) r
WHERE w.vendor = r.vendor
ORDER BY vendorI want to highlight rows where the "Ordered" and "Received" column do not match
12 and 12 would not be highlighted
12 and 10 would be highlighted.
I am looking for someone to walk me through the process, i have been researching for a couple of days now and have not found a solid solution. any help would be greatly appreciated.
0