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.