Hi Lynn,
It works great without the where clause.   I need to have where clause for multiple condition once I resolve  or know how to resolve the issue. 🙂 
Thank...

Hi Phil- Thank you for your prompt response.  GL_GeneralLedger is a table not a view.  I am...