title: SQL Incorrect Syntax Error
body: <p>*Here I have two tables Site and SiteCoordinate.
      and other tables are connected with each others.</p>
  
  <pre><code>    Site.UniqueIDName,       /* Site table with different fields */
      Site.Name AS SiteName, 
      Site.MarkerName, 
      Site.MarkerNumber,
      SiteCoordinate.LocationLat,   /* SiteCoordinate Table with Different field */
      SiteCoordinate.LocationLong, 
      SiteCoordinate.LocationHeight,  /* I need to display both tables records */
  </code></pre>
  
  <p>Create and Insert Data into tables.</p>
  
  <p><strong>Error:</strong></p>
  
  <p>I found an error incorrect syntax near ON and Where.</p>
  
  <pre><code>FROM   SiteCoordinate **ON** SiteCoordinate.SiteID ON Site.ID = SiteCoordinate.SiteID Left OUTER JOIN /* Syntax error */   /* is this the correct syntax */
          vwStationConfiguration RIGHT OUTER JOIN
          vwSite RIGHT OUTER JOIN   /* Outer Join */ 
          Site ON vwSite.ID = Site.ID ON vwStationConfiguration.SiteID = Site.ID LEFT OUTER JOIN  /* Outer Join */ 
          vwSiteSensorInformation ON Site.ID = vwSiteSensorInformation.SiteId LEFT OUTER JOIN  /* Outer Join */ 
          Person RIGHT OUTER JOIN  /* Outer Join */ 
          SiteContact ON Person.ID = SiteContact.PersonID ON Site.ID = SiteContact.SiteID LEFT OUTER JOIN         
          Agency ON SiteContact.AgencyID = Agency.ID
  WHERE   (SiteContact.SupportLevel = 1  or SiteContact.SupportLevel is NULL)
  </code></pre>
  
  <p>The above code is example of Inner Join and outer Join. Before this FROM   SiteCoordinate <strong>ON</strong> SiteCoordinate.SiteID ON Site.ID = SiteCoordinate.SiteID Left OUTER JOIN // the program is working properly but after this line found an error.</p>
  
  <p>And second thing </p>
  
  <pre><code>**:XML ON**    /* incorrect syntax near ':'. */
  </code></pre>