Different results come back for same query

Discussion created by rchandler on Oct 24, 2012
Latest reply on Oct 31, 2012 by Asle Frantzen

I have a query using left outer join so that I can include columns from first table and the second table. I ran it in PI SQL commander.


But I find something strange. Once or twice I can get results which include columns from first table and second table. But most of time, the results not include columns from the second table.


This seems really strange for me. Does any one have this issue before? How Can I resolve this issue? How can I get correct results?


Thanks in advance.