Hi there, I have 2 tables with foreign key relationship. I am trying to get all the orders for all the customers.In case customer does not have any order it should still be giving result with Null in order field. I am using Left Outer Join but i am not getting result for the customers who dont have any orders. Any clue? Thanks!