Drill Through Query Generation Dynamically

Hi All,

           We have  members in metaoutline (EX:LG_xx).When we do drill-thru in excel-addin by selecting those member, backend dynamically query will generate. But if i look at the query it is comparing this member name (LG_xx) with other table filed  (LG_xx=XX, we dont have prefix in this table). Due to this, I am not able to view the data in drill-thru. Can anyone pls suggest me? please look at the below code for better understanding.

select a.column1,a.column2,a.column3

from table1 a,table2 b
where a.column1=b.column1 and
a.column2=b.column2 and