Join query in doctrine symfony

Posted by THOmas on Stack Overflow See other posts from Stack Overflow or by THOmas
Published on 2010-03-18T07:41:54Z Indexed on 2010/03/18 8:01 UTC
Read the original article Hit count: 446

Filed under:
|
|
|

I have two tables userdetails and blog question The schema is

UserDetails:
  connection: doctrine
  tableName: user_details
  columns:
    id:
      type: integer(8)
      fixed: false
    name:
      type: string(255)
      fixed: false

BlogQuestion:
  connection: doctrine
  tableName: blog_question
  columns:
    question_id:
      type: integer(8)
      fixed: false
      unsigned: false
      primary: true
      autoincrement: true
    blog_id:
      type: integer(8)
      fixed: false
    user_id:
      type: integer(8)
      fixed: false
    question_title:
      type: string(255)

I am using one join query for retrieving all the questions and user details from this two tables My join query is

$q = Doctrine_Query::create()
    ->select('*')
    ->from('BlogQuestion u')
    ->leftJoin('u.UserDetails p');
    $q->execute();

But it is showing this error Unknown relation alias UserDetails

Pls anybody help me

Thanks in advance

© Stack Overflow or respective owner

Related posts about symfony

Related posts about doctrine