Hey All

I am new to Doctrine...

So I decided to learn doctrine to do queries and right away i got my self 
into troubles...(OOOooooPPPssss).

I have this query: 

public function getURLs()
{
     $stmt = $this->db->createQueryBuilder()
        ->select('af.news_id', 'af.tags_id')
        ->from('news_tags', 'af')
        ->leftJoin('a', 'news_tags', 'af', 'af.news_id = a.id')
        ->leftJoin('f', 'news_tags', 'af', 'af.news_id = f.id');

     $result = $stmt->execute()->fetch(\PDO::FETCH_OBJ);
}



I get then this error doent really know what it means and how I can fix it:


{
   
   - code: 0,
   - message: "The given alias 'a' is not part of any FROM or JOIN clause 
table. The currently registered aliases are: af."
   
}

-- 
You received this message because you are subscribed to the Google Groups 
"doctrine-user" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/doctrine-user.
For more options, visit https://groups.google.com/d/optout.

Reply via email to