When executing the following SQL query on Microsoft SQL Server 2008 :

```
SELECT 
   [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]
FROM [Pdata].[dbo].[Real_acct] 
LEFT JOIN [Pdata].[dbo].[Land] 
ON (Real_acct.ACCOUNT = LAND.ACCOUNT)

```

I get the following error:

```
Msg 209, Level 16, State 1, Line 1
Ambiguous column name 'ACCOUNT'.

```