SQL query

[webhay]

I have two customer and order table how can i return all customer has no orders. Thank you hoho

[P_pk]

i didn't get the clear picture.give the condition by using 'where'

PPK

[Krish KP]

your question is not clear. can you please provide table structure and sample data. which will help us in solving your query.

Regards KP

[webhay]

Thank you for you reply. I have customer table and Customer order and there is a PK in the customer table and FK in the order table i need to get all coustomer has no record in the order tables Thank you

[Krish KP]

this can be done using two methods 1. outer join 2. not exists you can choose one on these two.

Regards KP