Sorry for the syntax error on the IFNULL's. I'm glad you figured out what was wrong.
Albert On 08/04/2011 11:44 AM, J BLAUSTEIN wrote:
thank you for your help - I made a minor correction to your command to eliminate the error msg null command incorrect) I used the following - and everything work fine - I need to learn about inner and outer join functions - where do you recommend I find this informationJ**

