title: Nested query in SQL
body: <p>Here is my query:</p>
  
  <pre><code>SELECT Real_acct.[ACCOUNT]
    ,[Mailto]
    ,[Site_addr_1]
    ,[Site_addr_2]
    ,[Site_addr_3]
    ,[State_Class]
    ,[Map_Facet]
    ,[Key_Map]
    ,[Neighborhood_Code]
    ,[Neighborhood_Group]
    ,[Econ_Area]
    ,[Yr_Impr]
    ,[Acreage]
    ,[Prior_Total_Market_Value]
    ,[Land_Value]
    ,[Improvement_Value]
    ,[Extra_features_Value]
    ,[Total_Appraised_Value]
    ,[Total_Building_Area]
    ,[Econ_Bld_Class]
    ,[LAND_USE_CODE]
    ,[PROPERTY_NAME]
    ,[Building_other].[UNITS]
    ,[NET_RENT_AREA]
    ,[Related_Account_Number]
    ,[Agent_ID]
    ,[Agent_Name]
  
  FROM [Pdata].[dbo].[Real_acct] 
      LEFT JOIN [Pdata].[dbo].[Land] ON 
              (Real_acct.ACCOUNT = LAND.ACCOUNT)
      LEFT JOIN [Pdata].[dbo].[Building_other] ON 
              (Real_acct.ACCOUNT = Building_other.ACCOUNT)
      LEFT JOIN [Pdata].[dbo].[Parcel_tieback] ON 
              (Real_acct.ACCOUNT = Parcel_tieback.ACCOUNT)
      LEFT JOIN [Pdata].[dbo].[Real_acct_agents] ON 
              (Real_acct.ACCOUNT = Real_acct_agents.ACCOUNT)
  </code></pre>
  
  <p>I want to add this query as nested:</p>
  
  <pre><code>SELECT [ACCOUNT]
    ,[BUILDING_NUMBER]
    ,[FIXTURE_TYPE]
    ,[FIXTURE_DESCRIPTION]
    ,[UNITS]
  FROM [Pdata].[dbo].[Fixtures]
  WHERE FIXTURE_TYPE = 'OWR'
  </code></pre>
  
  <p>with Left join </p>
  
  <p>How can I do this, please help me.</p>