I am working on magento1.7.
Every single order has a customer name and email address saved within it.
However I guess, Magento only shows these details in the Customers > Manage Customers section if that person has created an account.
If the customer checked out as a guest then their name and email address are only saved within the order in the database.
so I am unable to find the list of all customer.
Is it possible to have a query that will scan every single order within the back end and get the customer's full name, their email address and order date ?
I want to find all the customer who has made orders (both as a registered user or guest) from the beginning of the store..
Could any one suggest some query ?