s4
diff s4-blog.sh @ 956:b8ce08814228
Keep all records
author | HIROSE Yuuji <yuuji@gentei.org> |
---|---|
date | Thu, 25 Nov 2021 11:18:25 +0900 |
parents | 420ad90116e6 |
children | 0d9caeab3d81 |
line diff
1.1 --- a/s4-blog.sh Tue Oct 26 13:16:29 2021 +0900 1.2 +++ b/s4-blog.sh Thu Nov 25 11:18:25 2021 +0900 1.3 @@ -778,7 +778,7 @@ 1.4 else 1.5 lshandoutsub "$owner" $brid "$tt" >/dev/null # Only create temp.table 1.6 fi 1.7 - tbls="$tbls${tbls:+ NATURAL JOIN }$tt" 1.8 + tbls="$tbls${tbls:+ LEFT NATURAL JOIN }$tt" 1.9 done 1.10 fi 1.11 sql=${SQL:-"SELECT * FROM $tbls;"}