title: select query in sql server 2008
body: <p>I have two tables </p>
  
  <pre><code>create table tblchildinfo
    (id int, name varchar(50), 
     pickuppointid int, dropdownpointid int)
  </code></pre>
  
  <p>and</p>
  
  <pre><code>create table tblpoint(pointid int, PointName varchar(50))
  </code></pre>
  
  <p>So I have primary table tblpoint and child table as tblchildinfo and i want to write a statement such that i will get child id, child name, pickuppointID, pickuppointName, dropdownpointId &amp; dropdownpoint name</p>
  
  <p>Using SQL Server</p>