ssudhamca

hello i want two table records in substring query table1 name (membermaster ) column names [B]mficode,centercode,membername[/B] values ex [B]045323,1061,shanthi[/B] table2 name (memberloanmaster) column names [B]loanrefcode ,centercode,closedate[/B] values ex [B]045323/1,1061,2009-04-03,[/B] both tables mficode and loanrefcode and centercode as comman, how do i select mficode and centercode and membername, compare with loanrefcode …