>>Both suggestions are exactly the same (but I was quicker :))
>>If you need to get records with no orders, change INNER JOIN to LEFT JOIN.
>
>Yes, this is what I was trying since five minutes. But, the example here is just a small SQL. The real SQL is several times bigger and I had to find a way to make it work with the LEFT JOIN.
>
>Thanks

I'd use CTE to make it mainteinable (SQL Server syntax only).