Thanks for that I think I understand. However, the resulting data needs to populate a 3 column table:
Col 1 - poit_supplier (Supplier Code - to be output only once for each supplier in the result)
Col 2 - sum(poit_valord) (Sum of ALL Orders for a supplier placed locally)
Col 3 - sum(poit_valord) (Sum of ALL Orders for a supplier placed non-locally)
I hope this clarifies what I'm trying to achieve? Any ideas greatly appreciated
Thanks
Sean