title: query in sql server 2005
body: <p>there are two tables ...know i need </p>
  
  <p>1st condition:
  all the records in table </p>
  
  <p>2 nd condition:</p>
  
  <p>In table2 i need only records which have data</p>
  
  <p>...i want one query for the aove two conditions...</p>