Sql ansi problem in script

Mon, 25 Jun 2012 14:36:54 GMT

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

Re: Sql ansi problem in script

Anonymous — Tue, 26 Jun 2012 00:45:31 GMT

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

topic Re: Sql ansi problem in script in QlikView

Sql ansi problem in script

Re: Sql ansi problem in script