SqlColumn c1 = e1.getColumn() ;
// Not in scope -- add a table to get it
TableDescNodes nodeTableDesc = request.getStore().getNodeTableDesc() ;
String tableAlias = request.genId(NodeBase) ;
SqlTable nTable = new SqlTable(tableAlias, nodeTableDesc.getTableName()) ;
String nodeKeyColName = nodeTableDesc.getNodeRefColName() ;
SqlColumn c2 = new SqlColumn(nTable, nodeKeyColName) ;
nTable.setValueColumnForVar(var, c2) ;
// Condition for value: triple table column = node table id/hash
nTable.addNote("Var: "+var) ;
SqlExpr cond = new S_Equal(c1, c2) ;
SqlNode n = SqlBuilder.leftJoin(request, sqlNode, nTable, cond) ;
return n ;
}