title: Query to retrieving records by country, state,city and location in a single row
body: <p><a href="https://i.stack.imgur.com/QpapM.png" rel="nofollow noreferrer">Table Data </a><a href="https://i.stack.imgur.com/vZHDZ.png" rel="nofollow noreferrer">Table structure</a></p>
  
  <p>How to get a Whole record by Query which selecting
  country state,city,location in a single Row.</p>
  
  <p>country Which will be select with country Id and State Parent Id will be that country Id and City Parent Id will be state Id  and Location parent Id will be city Id.</p>
  
  <p>In this way how to select that related records by each location and city and state and Country.</p>
  
  <p>Table Name : LocationMaster</p>
  
  <p>Example:
      India, Tamilnadu,chennai,Saidapet.</p>
  
  <p>Wanna Solution for this problem. </p>
  
  <p>Check out this given Image Below my table structure here.</p>