# HG changeset patch
# User HIROSE Yuuji <yuuji@gentei.org>
# Date 1637806705 -32400
# Node ID b8ce088142281f97bda976ad6953733f466e50b4
# Parent  946f2db59413fd484871e0a9ae7b6045b4cac99d
Keep all records

diff -r 946f2db59413 -r b8ce08814228 s4-blog.sh
--- a/s4-blog.sh	Wed Nov 10 20:52:04 2021 +0900
+++ b/s4-blog.sh	Thu Nov 25 11:18:25 2021 +0900
@@ -778,7 +778,7 @@
       else
 	lshandoutsub "$owner" $brid "$tt" >/dev/null # Only create temp.table
       fi
-      tbls="$tbls${tbls:+ NATURAL JOIN }$tt"
+      tbls="$tbls${tbls:+ LEFT NATURAL JOIN }$tt"
     done
   fi
   sql=${SQL:-"SELECT * FROM $tbls;"}