SQL Join Query VB (Pretty Sumple, I'm just learning)
===

I'm trying to make a query which has the same field in table A & 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?

        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("& 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