Subquery returned more then one result. Pull vals from a look up table into comma delimited list

I am trying to run a subquery that goes to a look table and pulls back multiple vals that I am putting into a comma delimited list and storing in one var. I am getting th Subquery returned more than 1 result error msg. But when I run the sub query on its own it just returns one result. This is the query:

SELECT     MJ_WELL.API, MJ_WELL.SPUD_DATE, MJ_WELL.WELL_STATUS, MJ_WELL.LATITUDE, MJ_WELL.LONGITUDE, MJ_WELL.MJW_ID,
                      MJ_WELL.PROVINCE_ID, + '1' + MJ_LOCATION_DLS.LOCATION_EXC + CONVERT(nvarchar, MJ_LOCATION_DLS.LSD) + '/' + CONVERT(nvarchar,
                      MJ_LOCATION_DLS.SECTION) + '-' + CONVERT(nvarchar, MJ_LOCATION_DLS.TOWNSHIP) + '-' + CONVERT(nvarchar, MJ_LOCATION_DLS.RANGE)
                      + '' + CONVERT(nvarchar, MJ_LOCATION_DLS.MERIDIAN_DIR) + '' + CONVERT(nvarchar, MJ_LOCATION_DLS.MERIDIAN) + '/0' + CONVERT(nvarchar,
                      MJ_LOCATION_DLS.EVENT_SEQ) + '' AS LOCATION, MJ_WELL.KELLY_BUSHING, CONVERT(nvarchar, MJ_WELL.TOTAL_DEPTH) + ' m' AS TDMETERS,
                          (SELECT     COALESCE (MJ_LOG_TYPE.NAME + ', ', '') + CAST(MJ_LOG_TYPE.NAME AS varchar(100)) AS LOGS
                            FROM          MJ_LOG_TYPE INNER JOIN
                                                   MJ_LOG ON MJ_LOG.LOG_TYPE_ID = MJ_LOG_TYPE.LOG_TYPE_ID INNER JOIN
                                                   MJ_WELL AS MJ_WELL_1 ON MJ_WELL.MJW_ID = MJ_LOG.MJW_ID
                            WHERE      (MJ_WELL.MJW_ID = 1)) AS Expr1
FROM         MJ_WELL AS MJ_WELL INNER JOIN
                      MJ_LOCATION_DLS ON MJ_WELL.MJW_ID = MJ_LOCATION_DLS.MJW_ID