List<CustomObject__c> = [select (select Body from Notes order by Id desc Limit 1) notes,Id from CustomObject__c];

(Note: ParentId:.... Body :...... Id: .....)

List<Note> notes = [Select Body from Note where ParentId in(select Id from CustomObject__c)];