> When I have select from many tables, for second and other tables I
> must write all theirs columns and make aliases for them - it isn't
> comfortable, I can make table_name.* to take all columns only for
> first table, for others I can't - for example:

> public function pobierzDaneDoWygenerowaniaPromocji()
>  {
>        $q = Doctrine_Query::create()
>          ->select('t.*, a.name_airline as name_airline, a.promotion as
> promotion)
>          ->from('Travel t')
>          ->innerJoin('t.Airline a');

>        return $q->execute();
>  }

> Is other way, because it isn't comfortable ?????

> example:

> public function pobierzDaneDoWygenerowaniaPromocji()
>  {
>        $q = Doctrine_Query::create()
>          ->from('Travel t')
>          ->innerJoin('t.Airline a');

>        return $q->execute();
>  }

> I wish that help

> 2009/11/6 dziobacz <aaabbbcccda...@gmail.com>

> > When I have select from many tables, for second and other tables I
> > must write all theirs columns and make aliases for them - it isn't
> > comfortable, I can make table_name.* to take all columns only for
> > first table, for others I can't - for example:

> > public function pobierzDaneDoWygenerowaniaPromocji()
> >  {
> >        $q = Doctrine_Query::create()
> >          ->select('t.*, a.name_airline as name_airline, a.promotion as
> > promotion)
> >          ->from('Travel t')
> >          ->innerJoin('t.Airline a');

> >        return $q->execute();
> >  }

> > Is other way, because it isn't comfortable ?????

> What if I have tables:

> tableA:
> id_tableA
> id_tableB
> id_tableC

> tableB:
> id_tableB

> tableC:
> id_tableC

> And query:

> public function someFunction()
>  {
>         $q = Doctrine_Query::create()
>           ->from('TableA a')
>          ->innerJoin('a.tableB b')
>           ->innerJoin('a.tableC c');

>        return $q->execute();
>  }

> How can I then show records ?

> On 6 Lis, 14:33, Daniel Santos Bathke <danielbat...@gmail.com> wrote:
> > If you dont use the method ->select() to tell what to bring, it will
> > understand that you want all fields .. once you are trying to select
> > table1.*, table2.*, i think thats more confortable not using the method
> > ->select();

> > example:

> > public function pobierzDaneDoWygenerowaniaPromocji()
> >  {
> >        $q = Doctrine_Query::create()
> >          ->from('Travel t')
> >          ->innerJoin('t.Airline a');

> >        return $q->execute();
> >  }

> > I wish that help

> > 2009/11/6 dziobacz <aaabbbcccda...@gmail.com>

> > > When I have select from many tables, for second and other tables I
> > > must write all theirs columns and make aliases for them - it isn't
> > > comfortable, I can make table_name.* to take all columns only for
> > > first table, for others I can't - for example:

> > > public function pobierzDaneDoWygenerowaniaPromocji()
> > >  {
> > >        $q = Doctrine_Query::create()
> > >          ->select('t.*, a.name_airline as name_airline, a.promotion as
> > > promotion)
> > >          ->from('Travel t')
> > >          ->innerJoin('t.Airline a');

> > >        return $q->execute();
> > >  }

> > > Is other way, because it isn't comfortable ?????

> 2009/11/6 dziobacz <aaabbbcccda...@gmail.com>

> > What if I have tables:

> > tableA:
> > id_tableA
> > id_tableB
> > id_tableC

> > tableB:
> > id_tableB

> > tableC:
> > id_tableC

> > And query:

> > public function someFunction()
> >  {
> >         $q = Doctrine_Query::create()
> >           ->from('TableA a')
> >          ->innerJoin('a.tableB b')
> >           ->innerJoin('a.tableC c');

> >        return $q->execute();
> >  }

> > How can I then show records ?

> > On 6 Lis, 14:33, Daniel Santos Bathke <danielbat...@gmail.com> wrote:
> > > If you dont use the method ->select() to tell what to bring, it will
> > > understand that you want all fields .. once you are trying to select
> > > table1.*, table2.*, i think thats more confortable not using the method
> > > ->select();

> > > example:

> > > public function pobierzDaneDoWygenerowaniaPromocji()
> > >  {
> > >        $q = Doctrine_Query::create()
> > >          ->from('Travel t')
> > >          ->innerJoin('t.Airline a');

> > >        return $q->execute();
> > >  }

> > > I wish that help

> > > 2009/11/6 dziobacz <aaabbbcccda...@gmail.com>

> > > > When I have select from many tables, for second and other tables I
> > > > must write all theirs columns and make aliases for them - it isn't
> > > > comfortable, I can make table_name.* to take all columns only for
> > > > first table, for others I can't - for example:

> > > > public function pobierzDaneDoWygenerowaniaPromocji()
> > > >  {
> > > >        $q = Doctrine_Query::create()
> > > >          ->select('t.*, a.name_airline as name_airline, a.promotion as
> > > > promotion)
> > > >          ->from('Travel t')
> > > >          ->innerJoin('t.Airline a');

> > > >        return $q->execute();
> > > >  }

> > > > Is other way, because it isn't comfortable ?????

> I have error: Unknown method Travel::getColumnA, Unknown method
> Travel::getColumnB, Unknown method Travel::getColumnC,  why ??

> Here is my tables and code:

> tableA:
>  id_tableA
>  id_tableB
>  id_tableC
>   columnA

> tableB:
>  id_tableB
>  columnB

> tableC:
>  id_tableC
>  columnC

> public function someFunction()
>  {
>        $q = Doctrine_Query::create()
>          ->from('TableA a')
>          ->innerJoin('a.tableB b')
>          ->innerJoin('a.tableC c');

>        return $q->execute();
>  }

> $list = Doctrine::getTable('Travel')->someFunction();

> foreach($list as $x):
>      echo $x->getColumnA();
>      echo $x->getColumnB();
>      echo $x->getColumnC();
> endforeach;

> On 6 Lis, 16:21, Daniel Santos Bathke <danielbat...@gmail.com> wrote:
> > if you use hydrate array then, the fields will be organized in indexes,
> if
> > you use scalar, the alias of the table will be the part of the name of
> the
> > field, example: a_id_tableA, a_id_tableB, b_id_tableB

> > 2009/11/6 dziobacz <aaabbbcccda...@gmail.com>

> > > What if I have tables:

> > > tableA:
> > > id_tableA
> > > id_tableB
> > > id_tableC

> > > tableB:
> > > id_tableB

> > > tableC:
> > > id_tableC

> > > And query:

> > > public function someFunction()
> > >  {
> > >         $q = Doctrine_Query::create()
> > >           ->from('TableA a')
> > >          ->innerJoin('a.tableB b')
> > >           ->innerJoin('a.tableC c');

> > >        return $q->execute();
> > >  }

> > > How can I then show records ?

> > > On 6 Lis, 14:33, Daniel Santos Bathke <danielbat...@gmail.com> wrote:
> > > > If you dont use the method ->select() to tell what to bring, it will
> > > > understand that you want all fields .. once you are trying to select
> > > > table1.*, table2.*, i think thats more confortable not using the
> method
> > > > ->select();

> > > > example:

> > > > public function pobierzDaneDoWygenerowaniaPromocji()
> > > >  {
> > > >        $q = Doctrine_Query::create()
> > > >          ->from('Travel t')
> > > >          ->innerJoin('t.Airline a');

> > > >        return $q->execute();
> > > >  }

> > > > I wish that help

> > > > 2009/11/6 dziobacz <aaabbbcccda...@gmail.com>

> > > > > When I have select from many tables, for second and other tables I
> > > > > must write all theirs columns and make aliases for them - it isn't
> > > > > comfortable, I can make table_name.* to take all columns only for
> > > > > first table, for others I can't - for example:

> > > > > public function pobierzDaneDoWygenerowaniaPromocji()
> > > > >  {
> > > > >        $q = Doctrine_Query::create()
> > > > >          ->select('t.*, a.name_airline as name_airline, a.promotion
> as
> > > > > promotion)
> > > > >          ->from('Travel t')
> > > > >          ->innerJoin('t.Airline a');

> > > > >        return $q->execute();
> > > > >  }

> > > > > Is other way, because it isn't comfortable ?????

> Use, ->setHydrationMode(Doctrine::HYDRATE_ARRAY) in your dql, and then
> print_r the result .. you will understand.

> 2009/11/6 dziobacz <aaabbbcccda...@gmail.com>

> > I have error: Unknown method Travel::getColumnA, Unknown method
> > Travel::getColumnB, Unknown method Travel::getColumnC,  why ??

> > Here is my tables and code:

> > tableA:
> >  id_tableA
> >  id_tableB
> >  id_tableC
> >   columnA

> > tableB:
> >  id_tableB
> >  columnB

> > tableC:
> >  id_tableC
> >  columnC

> > public function someFunction()
> >  {
> >        $q = Doctrine_Query::create()
> >          ->from('TableA a')
> >          ->innerJoin('a.tableB b')
> >          ->innerJoin('a.tableC c');

> >        return $q->execute();
> >  }

> > $list = Doctrine::getTable('Travel')->someFunction();

> > foreach($list as $x):
> >      echo $x->getColumnA();
> >      echo $x->getColumnB();
> >      echo $x->getColumnC();
> > endforeach;

> > On 6 Lis, 16:21, Daniel Santos Bathke <danielbat...@gmail.com> wrote:
> > > if you use hydrate array then, the fields will be organized in indexes,
> > if
> > > you use scalar, the alias of the table will be the part of the name of
> > the
> > > field, example: a_id_tableA, a_id_tableB, b_id_tableB

> > > 2009/11/6 dziobacz <aaabbbcccda...@gmail.com>

> > > > What if I have tables:

> > > > tableA:
> > > > id_tableA
> > > > id_tableB
> > > > id_tableC

> > > > tableB:
> > > > id_tableB

> > > > tableC:
> > > > id_tableC

> > > > And query:

> > > > public function someFunction()
> > > >  {
> > > >         $q = Doctrine_Query::create()
> > > >           ->from('TableA a')
> > > >          ->innerJoin('a.tableB b')
> > > >           ->innerJoin('a.tableC c');

> > > >        return $q->execute();
> > > >  }

> > > > How can I then show records ?

> > > > On 6 Lis, 14:33, Daniel Santos Bathke <danielbat...@gmail.com> wrote:
> > > > > If you dont use the method ->select() to tell what to bring, it will
> > > > > understand that you want all fields .. once you are trying to select
> > > > > table1.*, table2.*, i think thats more confortable not using the
> > method
> > > > > ->select();

> > > > > example:

> > > > > public function pobierzDaneDoWygenerowaniaPromocji()
> > > > >  {
> > > > >        $q = Doctrine_Query::create()
> > > > >          ->from('Travel t')
> > > > >          ->innerJoin('t.Airline a');

> > > > >        return $q->execute();
> > > > >  }

> > > > > I wish that help

> > > > > 2009/11/6 dziobacz <aaabbbcccda...@gmail.com>

> > > > > > When I have select from many tables, for second and other tables I
> > > > > > must write all theirs columns and make aliases for them - it isn't
> > > > > > comfortable, I can make table_name.* to take all columns only for
> > > > > > first table, for others I can't - for example:

> > > > > > public function pobierzDaneDoWygenerowaniaPromocji()
> > > > > >  {
> > > > > >        $q = Doctrine_Query::create()
> > > > > >          ->select('t.*, a.name_airline as name_airline, a.promotion
> > as
> > > > > > promotion)
> > > > > >          ->from('Travel t')
> > > > > >          ->innerJoin('t.Airline a');

> > > > > >        return $q->execute();
> > > > > >  }

> > > > > > Is other way, because it isn't comfortable ?????

> I understand but I don't know how can I in that case make loop. The
> problem is that table TableA has 2 FK, please help with loop.

> On 6 Lis, 18:08, Daniel Santos Bathke <danielbat...@gmail.com> wrote:
> > Its because $x does not have a columnB .. $x is a record from TableA, you
> > have to get the child element .. every innerJoin table has a child
> element
> > ..

> > Use, ->setHydrationMode(Doctrine::HYDRATE_ARRAY) in your dql, and then
> > print_r the result .. you will understand.

> > 2009/11/6 dziobacz <aaabbbcccda...@gmail.com>

> > > I have error: Unknown method Travel::getColumnA, Unknown method
> > > Travel::getColumnB, Unknown method Travel::getColumnC,  why ??

> > > Here is my tables and code:

> > > tableA:
> > >  id_tableA
> > >  id_tableB
> > >  id_tableC
> > >   columnA

> > > tableB:
> > >  id_tableB
> > >  columnB

> > > tableC:
> > >  id_tableC
> > >  columnC

> > > public function someFunction()
> > >  {
> > >        $q = Doctrine_Query::create()
> > >          ->from('TableA a')
> > >          ->innerJoin('a.tableB b')
> > >          ->innerJoin('a.tableC c');

> > >        return $q->execute();
> > >  }

> > > $list = Doctrine::getTable('Travel')->someFunction();

> > > foreach($list as $x):
> > >      echo $x->getColumnA();
> > >      echo $x->getColumnB();
> > >      echo $x->getColumnC();
> > > endforeach;

> > > On 6 Lis, 16:21, Daniel Santos Bathke <danielbat...@gmail.com> wrote:
> > > > if you use hydrate array then, the fields will be organized in
> indexes,
> > > if
> > > > you use scalar, the alias of the table will be the part of the name
> of
> > > the
> > > > field, example: a_id_tableA, a_id_tableB, b_id_tableB

> > > > 2009/11/6 dziobacz <aaabbbcccda...@gmail.com>

> > > > > What if I have tables:

> > > > > tableA:
> > > > > id_tableA
> > > > > id_tableB
> > > > > id_tableC

> > > > > tableB:
> > > > > id_tableB

> > > > > tableC:
> > > > > id_tableC

> > > > > And query:

> > > > > public function someFunction()
> > > > >  {
> > > > >         $q = Doctrine_Query::create()
> > > > >           ->from('TableA a')
> > > > >          ->innerJoin('a.tableB b')
> > > > >           ->innerJoin('a.tableC c');

> > > > >        return $q->execute();
> > > > >  }

> > > > > How can I then show records ?

> > > > > On 6 Lis, 14:33, Daniel Santos Bathke <danielbat...@gmail.com>
> wrote:
> > > > > > If you dont use the method ->select() to tell what to bring, it
> will
> > > > > > understand that you want all fields .. once you are trying to
> select
> > > > > > table1.*, table2.*, i think thats more confortable not using the
> > > method
> > > > > > ->select();

> > > > > > example:

> > > > > > public function pobierzDaneDoWygenerowaniaPromocji()
> > > > > >  {
> > > > > >        $q = Doctrine_Query::create()
> > > > > >          ->from('Travel t')
> > > > > >          ->innerJoin('t.Airline a');

> > > > > >        return $q->execute();
> > > > > >  }

> > > > > > I wish that help

> > > > > > 2009/11/6 dziobacz <aaabbbcccda...@gmail.com>

> > > > > > > When I have select from many tables, for second and other
> tables I
> > > > > > > must write all theirs columns and make aliases for them - it
> isn't
> > > > > > > comfortable, I can make table_name.* to take all columns only
> for
> > > > > > > first table, for others I can't - for example:

> > > > > > > public function pobierzDaneDoWygenerowaniaPromocji()
> > > > > > >  {
> > > > > > >        $q = Doctrine_Query::create()
> > > > > > >          ->select('t.*, a.name_airline as name_airline,
> a.promotion
> > > as
> > > > > > > promotion)
> > > > > > >          ->from('Travel t')
> > > > > > >          ->innerJoin('t.Airline a');

> > > > > > >        return $q->execute();
> > > > > > >  }

> > > > > > > Is other way, because it isn't comfortable ?????

>             foreach($tableA as $indexa => $a)
>             {
>                     foreach($a['tableB'] as $indexb => $b)
>                     {
>                             echo $b['columnB'];
>                     }
>             }

> 2009/11/6 dziobacz <aaabbbcccda...@gmail.com>

> > I understand but I don't know how can I in that case make loop. The
> > problem is that table TableA has 2 FK, please help with loop.

> > On 6 Lis, 18:08, Daniel Santos Bathke <danielbat...@gmail.com> wrote:
> > > Its because $x does not have a columnB .. $x is a record from TableA, you
> > > have to get the child element .. every innerJoin table has a child
> > element
> > > ..

> > > Use, ->setHydrationMode(Doctrine::HYDRATE_ARRAY) in your dql, and then
> > > print_r the result .. you will understand.

> > > 2009/11/6 dziobacz <aaabbbcccda...@gmail.com>

> > > > I have error: Unknown method Travel::getColumnA, Unknown method
> > > > Travel::getColumnB, Unknown method Travel::getColumnC,  why ??

> > > > Here is my tables and code:

> > > > tableA:
> > > >  id_tableA
> > > >  id_tableB
> > > >  id_tableC
> > > >   columnA

> > > > tableB:
> > > >  id_tableB
> > > >  columnB

> > > > tableC:
> > > >  id_tableC
> > > >  columnC

> > > > public function someFunction()
> > > >  {
> > > >        $q = Doctrine_Query::create()
> > > >          ->from('TableA a')
> > > >          ->innerJoin('a.tableB b')
> > > >          ->innerJoin('a.tableC c');

> > > >        return $q->execute();
> > > >  }

> > > > $list = Doctrine::getTable('Travel')->someFunction();

> > > > foreach($list as $x):
> > > >      echo $x->getColumnA();
> > > >      echo $x->getColumnB();
> > > >      echo $x->getColumnC();
> > > > endforeach;

> > > > On 6 Lis, 16:21, Daniel Santos Bathke <danielbat...@gmail.com> wrote:
> > > > > if you use hydrate array then, the fields will be organized in
> > indexes,
> > > > if
> > > > > you use scalar, the alias of the table will be the part of the name
> > of
> > > > the
> > > > > field, example: a_id_tableA, a_id_tableB, b_id_tableB

> > > > > 2009/11/6 dziobacz <aaabbbcccda...@gmail.com>

> > > > > > What if I have tables:

> > > > > > tableA:
> > > > > > id_tableA
> > > > > > id_tableB
> > > > > > id_tableC

> > > > > > tableB:
> > > > > > id_tableB

> > > > > > tableC:
> > > > > > id_tableC

> > > > > > And query:

> > > > > > public function someFunction()
> > > > > >  {
> > > > > >         $q = Doctrine_Query::create()
> > > > > >           ->from('TableA a')
> > > > > >          ->innerJoin('a.tableB b')
> > > > > >           ->innerJoin('a.tableC c');

> > > > > >        return $q->execute();
> > > > > >  }

> > > > > > How can I then show records ?

> > > > > > On 6 Lis, 14:33, Daniel Santos Bathke <danielbat...@gmail.com>
> > wrote:
> > > > > > > If you dont use the method ->select() to tell what to bring, it
> > will
> > > > > > > understand that you want all fields .. once you are trying to
> > select
> > > > > > > table1.*, table2.*, i think thats more confortable not using the
> > > > method
> > > > > > > ->select();

> > > > > > > example:

> > > > > > > public function pobierzDaneDoWygenerowaniaPromocji()
> > > > > > >  {
> > > > > > >        $q = Doctrine_Query::create()
> > > > > > >          ->from('Travel t')
> > > > > > >          ->innerJoin('t.Airline a');

> > > > > > >        return $q->execute();
> > > > > > >  }

> > > > > > > I wish that help

> > > > > > > 2009/11/6 dziobacz <aaabbbcccda...@gmail.com>

> > > > > > > > When I have select from many tables, for second and other
> > tables I
> > > > > > > > must write all theirs columns and make aliases for them - it
> > isn't
> > > > > > > > comfortable, I can make table_name.* to take all columns only
> > for
> > > > > > > > first table, for others I can't - for example:

> > > > > > > > public function pobierzDaneDoWygenerowaniaPromocji()
> > > > > > > >  {
> > > > > > > >        $q = Doctrine_Query::create()
> > > > > > > >          ->select('t.*, a.name_airline as name_airline,
> > a.promotion
> > > > as
> > > > > > > > promotion)
> > > > > > > >          ->from('Travel t')
> > > > > > > >          ->innerJoin('t.Airline a');

> > > > > > > >        return $q->execute();
> > > > > > > >  }

> > > > > > > > Is other way, because it isn't comfortable ?????

> This is so difficult - I have error: Uninitialized string offset: 0

> On 6 Lis, 18:35, Daniel Santos Bathke <danielbat...@gmail.com> wrote:
> > You can do this if you use HYDRATE_ARRAY method:

> >             foreach($tableA as $indexa => $a)
> >             {
> >                     foreach($a['tableB'] as $indexb => $b)
> >                     {
> >                             echo $b['columnB'];
> >                     }
> >             }

> > 2009/11/6 dziobacz <aaabbbcccda...@gmail.com>

> > > I understand but I don't know how can I in that case make loop. The
> > > problem is that table TableA has 2 FK, please help with loop.

> > > On 6 Lis, 18:08, Daniel Santos Bathke <danielbat...@gmail.com> wrote:
> > > > Its because $x does not have a columnB .. $x is a record from TableA,
> you
> > > > have to get the child element .. every innerJoin table has a child
> > > element
> > > > ..

> > > > Use, ->setHydrationMode(Doctrine::HYDRATE_ARRAY) in your dql, and
> then
> > > > print_r the result .. you will understand.

> > > > 2009/11/6 dziobacz <aaabbbcccda...@gmail.com>

> > > > > I have error: Unknown method Travel::getColumnA, Unknown method
> > > > > Travel::getColumnB, Unknown method Travel::getColumnC,  why ??

> > > > > Here is my tables and code:

> > > > > tableA:
> > > > >  id_tableA
> > > > >  id_tableB
> > > > >  id_tableC
> > > > >   columnA

> > > > > tableB:
> > > > >  id_tableB
> > > > >  columnB

> > > > > tableC:
> > > > >  id_tableC
> > > > >  columnC

> > > > > public function someFunction()
> > > > >  {
> > > > >        $q = Doctrine_Query::create()
> > > > >          ->from('TableA a')
> > > > >          ->innerJoin('a.tableB b')
> > > > >          ->innerJoin('a.tableC c');

> > > > >        return $q->execute();
> > > > >  }

> > > > > $list = Doctrine::getTable('Travel')->someFunction();

> > > > > foreach($list as $x):
> > > > >      echo $x->getColumnA();
> > > > >      echo $x->getColumnB();
> > > > >      echo $x->getColumnC();
> > > > > endforeach;

> > > > > On 6 Lis, 16:21, Daniel Santos Bathke <danielbat...@gmail.com>
> wrote:
> > > > > > if you use hydrate array then, the fields will be organized in
> > > indexes,
> > > > > if
> > > > > > you use scalar, the alias of the table will be the part of the
> name
> > > of
> > > > > the
> > > > > > field, example: a_id_tableA, a_id_tableB, b_id_tableB

> > > > > > 2009/11/6 dziobacz <aaabbbcccda...@gmail.com>

> > > > > > > What if I have tables:

> > > > > > > tableA:
> > > > > > > id_tableA
> > > > > > > id_tableB
> > > > > > > id_tableC

> > > > > > > tableB:
> > > > > > > id_tableB

> > > > > > > tableC:
> > > > > > > id_tableC

> > > > > > > And query:

> > > > > > > public function someFunction()
> > > > > > >  {
> > > > > > >         $q = Doctrine_Query::create()
> > > > > > >           ->from('TableA a')
> > > > > > >          ->innerJoin('a.tableB b')
> > > > > > >           ->innerJoin('a.tableC c');

> > > > > > >        return $q->execute();
> > > > > > >  }

> > > > > > > How can I then show records ?

> > > > > > > On 6 Lis, 14:33, Daniel Santos Bathke <danielbat...@gmail.com>
> > > wrote:
> > > > > > > > If you dont use the method ->select() to tell what to bring,
> it
> > > will
> > > > > > > > understand that you want all fields .. once you are trying to
> > > select
> > > > > > > > table1.*, table2.*, i think thats more confortable not using
> the
> > > > > method
> > > > > > > > ->select();

> > > > > > > > example:

> > > > > > > > public function pobierzDaneDoWygenerowaniaPromocji()
> > > > > > > >  {
> > > > > > > >        $q = Doctrine_Query::create()
> > > > > > > >          ->from('Travel t')
> > > > > > > >          ->innerJoin('t.Airline a');

> > > > > > > >        return $q->execute();
> > > > > > > >  }

> > > > > > > > I wish that help

> > > > > > > > 2009/11/6 dziobacz <aaabbbcccda...@gmail.com>

> > > > > > > > > When I have select from many tables, for second and other
> > > tables I
> > > > > > > > > must write all theirs columns and make aliases for them -
> it
> > > isn't
> > > > > > > > > comfortable, I can make table_name.* to take all columns
> only
> > > for
> > > > > > > > > first table, for others I can't - for example:

> > > > > > > > > public function pobierzDaneDoWygenerowaniaPromocji()
> > > > > > > > >  {
> > > > > > > > >        $q = Doctrine_Query::create()
> > > > > > > > >          ->select('t.*, a.name_airline as name_airline,
> > > a.promotion
> > > > > as
> > > > > > > > > promotion)
> > > > > > > > >          ->from('Travel t')
> > > > > > > > >          ->innerJoin('t.Airline a');

> > > > > > > > >        return $q->execute();
> > > > > > > > >  }

> > > > > > > > > Is other way, because it isn't comfortable ?????