Hi luke,
Thanks for the reply. I did give a try using the RAW SQL query but got an error message in the resloved query. Here is the message
"Raw Sql Query cannot be Resolved:
An unexpected SQL error occurred when retrieving the schema from the RawSqlDataSource."
Please let me know if i'm doing it wrong.The query builder does not let me copy your code.
thanks