[turba] sql data from 2 different tables

[Terry]

I got it working.  My table definition is correct.  The fields need to
be table.field:

        'name' => 'mos_users.name',
        'email' => 'mos_users.email',


On 11/8/05, Terry <td3201 at gmail.com> wrote:
> Ok, I think I know the direction I need to head now.  Only getting errors:
>
> Nov 08 11:49:06 HORDE [debug] [turba] SQL query by
> Turba_Driver_sql::_search(): SELECT id, name, firstname FROM mos_users
> LEFT JOIN mos_comprofiler ON mos_users.id=mos_comprofiler.id WHERE
> (LOWER(name) LIKE LOWER(?)) [on line 80 of
> "/home/apache/www.asdfasdf.org/horde/turba/lib/Driver/sql.php"]
> Nov 08 11:49:06 HORDE [error] [turba] DB Error: unknown error: SELECT
> id, name, firstname FROM mos_users LEFT JOIN mos_comprofiler ON
> mos_users.id=mos_comprofiler.id WHERE (LOWER(name) LIKE LOWER('%%'))
> [nativecode=1052 ** Column 'id' in field list is ambiguous] [on line
> 85 of "/home/apache/www.asdfasdf.org/horde/turba/lib/Driver/sql.php"]
>
>
> Here is my table name:
> 'table' => 'mos_users LEFT JOIN mos_comprofiler ON
> mos_users.id=mos_comprofiler.id',
>
> mos_users.id == int(11)
> mos_comprofiler.id == int(11)
>
> On 11/7/05, Jan Schneider <jan at horde.org> wrote:
> > Zitat von Terry <td3201 at gmail.com>:
> >
> > > Could I get an example of a join statement for this?
> >
> > No, because only you know how these tables are correctly joined.
> >
> > > On 11/4/05, Adam Tauno Williams <adam at morrison-ind.com> wrote:
> > >> > > I want to have a single source but the data I need is in 2 separate
> > >> > > tables.  How can I make this work?
> > >> > Enter a JOIN statement as the table name.
> >
> > Jan.
> >
> > --
> > Do you need professional PHP or Horde consulting?
> > http://horde.org/consulting/
> >
> > --
> > Turba mailing list - Join the hunt: http://horde.org/bounties/#turba
> > Frequently Asked Questions: http://horde.org/faq/
> > To unsubscribe, mail: turba-unsubscribe at lists.horde.org
> >
>