InsertObjectB.sql

INSERT INTO salesforce.objectb(name, objectaid__r__external_id__c)
SELECT 'My First Object B record ', objectaid__r__external_id__c
FROM salesforce.objecta__c where id=1234;