Hi Mike, Virtual beer for you, worked like a charm!
Cheers On Jun 18, 10:58 am, m1chael <[email protected]> wrote: > Hi! > > Something like this would work in PostgreSQL, i'm not sure about MySQL > though: > > select first_name,last_name,email from contact_contact where id in (select > contact_id from shop_order); > > Hope it works out for you! :) > > Maybe someone else can add more to this, > > ~Mike > > On Fri, Jun 18, 2010 at 1:41 PM, Ricko <[email protected]> wrote: > > Hi all, > > > I have a client who wishes to get a list of all the customers who made > > purchases on his Satchmo site. Can anyone assist in the correct SQL > > statement? The admin gets close to doing that without needing a db > > query, but it doesn't look like you can output the table data as .csv > > or anything useful. > > > Cheers > > > -- > > You received this message because you are subscribed to the Google Groups > > "Satchmo users" group. > > To post to this group, send email to [email protected]. > > To unsubscribe from this group, send email to > > [email protected]<satchmo-users%[email protected]> > > . > > For more options, visit this group at > >http://groups.google.com/group/satchmo-users?hl=en. > > -- You received this message because you are subscribed to the Google Groups "Satchmo users" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/satchmo-users?hl=en.
