Thank you for the prompt response namliam.
I still have the same problem doing it this way, I have tried both combinations and it is still not giving me a 0, it just leaves out the beans.
It says in the descripotion of the join, include all records from table 1 and only those from table 2...