Write a query: I have 1 parent(account) and 1 child(contact),how will you get F.name,L.name from child and email from the account when Organization name in acc

Hi Manpreet,

You can use this query

select name, (select firstname,lastname from contacts) from Account where name=’CTS’

You can change the fields to the Required Fields according to your need