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
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
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