Do you mean the 000000 As QtyOut and 000000 As QtyIn?
I may not need them. I'll try it without them. I suppose that I don't need them. Do you teach SQL coding?
Cecil
>Hi Cecil,
>Maybe I'm missing something but why do you need second quantity field and JOIN to the Customer table in the subselects?