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.