Thanks for your response.

before giving up on it , I am still curious to know is there any way to fix the sql query?