totals query - group by email max of date
in [General]
|
From: jenny molina on 16 Apr 2010 21:10 "ZenMasta" <me(a)nospam.kthx> wrote in message news:OLULCsa3KHA.5588(a)TK2MSFTNGP06.phx.gbl... > Maybe we should start over because I'm not sure any of this is really > working out. > > table1 has these fields > customer_id > customer_firstname > customer_lastname > customer_email > > table2 has these fields > customer_id > opt_date > customerIP > > I really wish this was originally designed with one table in the first > place but it wasn't so this is what I'm stuck with. > >
From: silvio pizzorni on 17 Apr 2010 09:49
"ZenMasta" <me(a)nospam.kthx> ha scritto nel messaggio news:OLULCsa3KHA.5588(a)TK2MSFTNGP06.phx.gbl... > Maybe we should start over because I'm not sure any of this is really > working out. > > table1 has these fields > customer_id > customer_firstname > customer_lastname > customer_email > > table2 has these fields > customer_id > opt_date > customerIP > > I really wish this was originally designed with one table in the first > place but it wasn't so this is what I'm stuck with. > > |