Magento - Select some customer infos

for the purpose of a module that I began to realize, I want to make a select query which gives m开发者_C百科e the address, name and surname of one or more clients.

I am a bit lost in the database magento, Help!

You can echo out each select magento does with getSelect() method.

for one client

echo Mage::getModel('customer/customer')->load('id')->getSelect();

or whole collection

echo Mage::getModel('customer/customer')->getCollection()->getSelect();

You must search the tables customer_entity and customer_address_entity