Foreign key with primary key SQL join query

 SELECT ua.Username, e.UpdatedOn, e.Remarks from icms_UserAccount ua join icms_employee e on e.UpdatedBy = ua.UserID WHERE e.MainID = @MainID AND e.Remarks IS NOT NULL AND e.Remarks <> '';