>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