title: SQL Join Query VB (Pretty Sumple, I'm just learning)
body: <p>I'm trying to make a query which has the same field in table A &amp; table B.  Then table B has the same field as table C.  I want to left join all tables on table A.  Is this possible?  If yes, how close is my code to doing it?</p>
  
  <pre><code>    Try
              objConn = DBAccess.GetConnection
              strBlder.Append("SELECT ")
              strBlder.Append("FLD_NM, DATA_TYPE_CD, XML_PATH_TX, UPDT_USER_ID_NR, DOC_TMPL_FLD_ID_NR  ")
              strBlder.Append("FROM ")
              strBlder.Append("LLC.[LLCW10_DCTMPFLD_TB] LEFT JOIN LLC.[DataMapTool_FieldMapping] ")
              strBlder.Append("ON LLC.[LLCW10_DCTMPFLD_TB].DOC_TMPL_FLD_ID_NR = LLC.[DataMapTool_FieldMapping].DocumentTemplateFieldID ")
              strBlder.Append("&amp; LEFT JOIN LLC.[DataMapTool_FieldMapping] ")
              strBlder.Append("ON LLC.[DataMapTool_FieldMapping].FieldMappingStatusID = LLC.[DataMapTool_FieldMappingStatus].FieldMappingStatusID ")
  
              strBlder.Append("ORDER BY FLD_NM ;")
              dsData = DBAccess.ExecuteDataTable(objConn, CommandType.Text, strBlder.ToString())
              'execute non query - takes sp name
  </code></pre>