I have a Lead object and would like to get all contacts for this Lead. I was not able to find an appropriate method in apex and decided to make a query. Unfortunately I don't have much experience with SOQL therefore could you please advise how to adapt the following query in SOQL. Here is the query:
select contact.* from lead, contact where lead.id = contact.Company_Name__c and lead.id = '00Q560000019qCB'
Please advise how to transform the above query in SOQL?
Regards,
Dilyan