how to query all account and account relate address in one soql?

Question

I am freshman in salesforce dev. but, today, i am facing a little issue. i want query all account address record and insert to new object.

i have following query:

for account: SELECT Name FROM Account

for address: SELECT Account_vod__c, Name, Address_line_2_vod__c FROM Address_vod__c

but, i don't know that how to join two sqls in one?

if you konw it, please tell me that how to do this?

Many thanks

Answer 1

What you are performing here is a relationship query. The documentation about relationship queries can be found here: Force.com SOQL and SOSL Reference: Relationship Queries I would highly suggest reading the documentation to get a better understanding of the syntax to perform this type of query and how to work with the results.

Each Account will have a List<Address_vod__c> children under it which you can access using the relationship syntax.

Your query for an Account with it's child Address_vod__c records will likely look like this:

List<Account> accounts = [SELECT Id
                            , Name
                            , (SELECT Id
                                    , Account_vod__c
                                    , Name
                                    , Address_line_2_vod__c 
                                    FROM Address_vod__r)
                            FROM Account
                            LIMIT 10];

// iterate over the Accounts
for (Account a : accounts) {
    system.debug('Account: ' + a);

    // iterate over the Address_vod__c records under the Account 
    // using the relationship syntax
    for (Address_vod__c addressVOD : a.Address_vod__r) {
        system.debug('Address VOD: ' + addressVOD);

    }
}