T
TheMadDBA
Guest
select * from PUB.idh_hist, , PUB.IH_HIST ih_hist WHERE ih_hist.ih_domain = idh_hist.idh_domain AND ih_hist.ih_inv_nbr = idh_hist.idh_inv_nbr AND ih_hist.ih_nbr = idh_hist.idh_nbr AND (substr('DAILY',1,4) != 'DAIL' OR (substr('DAILY',1,4) = 'DAIL' AND ih_hist.ih_inv_date sysdate()-10 ) ) What happens when you remove all of the DAILY substr options and use an actual date instead of sysdate? Other than that it seems like a pretty straightforward query (not 100% sure you need ih_nbr and idh_nbr but it has been a while since I used QAD). Edit to add: There are some bugs with using minus and intersect but nothing that I can see for a query this simple. I would just try making the query even simpler and contact support.
Continue reading...
Continue reading...