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.
