I cannot make any sense of what you're trying to accomplish. Could you describe what your entities are named? And (in english, not code) what you are querying for?
-- Jasper N. Brouwer (@jaspernbrouwer) On 26 November 2014 at 18:11:28, [email protected] ([email protected]) wrote: > 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.
