Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Sql ansi problem in script

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

1 Reply
Anonymous
Not applicable
Author

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