B
bvy
Guest
Thank you. Sorry for the late reply. I'm not at liberty to post very much about our environment, but the problem query is dead simple; it joins a header and detail table (ih_hist to idh_hist) and has a restriction on invoice date (ih_hist.ih_inv_date sysdate() - 10). The query does use, what I'll call, an "old style" join -- meaning it lists the tables and the join criteria are in the where clause (from a, b where a.col1 = b.col1 and a.col2 = b.col2). Could this be the culprit? When the query goes off as described, a.col1 b.col1 in the returned recordset indicating that the join criteria were, in effect, disregarded.
Continue reading...
Continue reading...