Anyone who can help. I am trying to do an outer join on this statement.

and h.mal_emal_code like 'W%' or h.mal_emal_code like 'Personal'

I am having trouble trying to set up where the (+) goes in the syntax. Any help would be appreciated. Thanks!!!!! DAO

Hi,

Perhaps your query could be written in a more standard way without (+).
Tell us how your data is defined and what you are trying to achieve.

Best Regards,
Dimitar