Re: [libreoffice-users] base - join same table multiple times

2012-01-23 Thread Dan Lewis
On Mon, 2012-01-23 at 13:14 -0500, Calvin Kim wrote: > > On 01/23/2012 08:26 AM, Werner F. Bruhin wrote: > > I have the following: > > > > tablea > > - id > > - name > > > > > > tableb > > - id > > - type > > - total > > - tablea_id > > > > In tableb there can be multiple records for a record in t

Re: [libreoffice-users] base - join same table multiple times

2012-01-23 Thread Calvin Kim
On 01/23/2012 08:26 AM, Werner F. Bruhin wrote: I have the following: tablea - id - name tableb - id - type - total - tablea_id In tableb there can be multiple records for a record in tablea. Like to get to this: tablea.id, tablea.name, tableb1.total1 (if type = 1), tableb2.total2 (if ty

[libreoffice-users] base - join same table multiple times

2012-01-23 Thread Werner F. Bruhin
I have the following: tablea - id - name tableb - id - type - total - tablea_id In tableb there can be multiple records for a record in tablea. Like to get to this: tablea.id, tablea.name, tableb1.total1 (if type = 1), tableb2.total2 (if type = 2) I tried to setup a view where I link tabl