title: how to get a field value from more than 7 tables using where condition
body: <p>I have a flat file which consists of a list of mobile numbers and their status as active or inactive.So my job is to write a SQL query such that i need to fetch a list of 7 tables for a particular msisdn and i have to get the status of the msisdn.So any suggestion how to write.</p>
  
  <p>I cannot use joins. </p>