public function subQuery( $table, $alias=null )
    {
        $sub = new self();
        if( !$alias ) $alias = 'sub_' . $this->subQueryCount ++;
        $sub->table( $table, $alias );
        $sub->setParentTable( $this->getAliasOrTable() );
        return $sub;
    }