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!

Hi Danny,

 Please send me in a basic overview of the table structure so that I could work that out for you.

Regards,

Surya 

Hi Danny,

A quick reply could be, if you are using conditions in the WHERE clause try moving them to the Left Outer join . Try this out and let me know, as Conditions in WHERE Clause would result in INNER JOIN based on the conditions you have inputted in the WHERE Clause

danny123:

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!

Post the code you used

Thanks everyone for quick responses but Where clause was causing the issue. I just needed to twick the joins between tables and it worked.

Thanks!

If you can post the code it helps to identify the root cause of the issue than suggesting shot in dark.

satya:

If you can post the code it helps to identify the root cause of the issue than suggesting shot in dark.

Issue already resolved, I guess.

FrankKalis:

satya:

If you can post the code it helps to identify the root cause of the issue than suggesting shot in dark.

 

Issue already resolved, I guess.

But still there may be chance for improvement if posted

I would like to see the problamatic and workable query