1 files changed, 3 insertions, 0 deletions
diff --git a/src/select.c b/src/select.c
index b1a1ea507..798df06e1 100644
--- a/src/select.c
+++ b/src/select.c
@@ -407,6 +407,9 @@ static void unsetJoinExpr(Expr *p, int iTable){
      && (iTable<0 || p->iRightJoinTable==iTable) ){
       ExprClearProperty(p, EP_FromJoin);
     }
+    if( p->op==TK_COLUMN && p->iTable==iTable ){
+      ExprClearProperty(p, EP_CanBeNull);
+    }
     if( p->op==TK_FUNCTION && p->x.pList ){
       int i;
       for(i=0; i<p->x.pList->nExpr; i++){