Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear all
i need your help!
i have a simple sql query that return about 250.000 records if i run via sqldeveloper. (oracle db )
The same query return 16.000 record if i run via qlikview.
I don't find the problem.
The only peculiarity is the sql ansi sintax for join .. .
See attached file for query detail .
Best Regards and thank's for your help
Riccardo
Riccardo,
If I had a chance to test it, I would do it by disabling lines in the WHERE clause, hence narrowing down the problem. And, the lines I'd test first are these:
and trunc(pll.last_update_date) between to_date('11/10/2011','dd/mm/yyyy') and sysdate+1
and tr.po_line_Location_id ( + ) = pll.line_location_id
AND tr.transaction_type ( + ) = 'DELIVER'
Because not sure how the bold items above work there.
Regards,
Michael