<b> INNER JOIN SiteMstr ON SiteMstr.Town = Towns.Town AND SiteMstr.Town = "GOSN" </b>Leave only conditions on TranMstr in the WHERE clause. The WHERE takes precedence over the join and will not return nulls to match the TranMstr records.
>SELECT * FROM tranmstr ; left JOIN misclndr on tranmstr.tranid = misclndr.tranid ; inner JOIN propmstr on tranmstr.propid = propmstr.propid ; inner JOIN sitemstr on tranmstr.propid = sitemstr.propid ; left JOIN bldgmstr on tranmstr.propid = bldgmstr.propid ; <b>right join Towns on SiteMstr.Town=Towns.Town</b> ; where (prefcode = "P" and sitemstr.town="GOSN" and SOURCE="S") ; and between(tranmstr.extrYear+tranmstr.extrWeek ,oJC.LowWeek, oJC.HighWeek) ; INTO TABLE &qry_arg3 >