Select Id from Account where Id IN (Select AccountId from contact where lastname='test contact')
@Mtripathi347 Жыл бұрын
perfect.
@crux096610 ай бұрын
@@Mtripathi347How about this? Set accountIds = (new Map ([Select Count(id), AccountId Id from Contact where lastname='Test Contact' Group by accountId])).keySet();
@NeerajKumar-kq5dl11 ай бұрын
SELECT Id, Name FROM Account WHERE Id IN (SELECT AccountId FROM Contact WHERE LastName LIKE '%Test')
@ukuleleguy16cs3610 ай бұрын
SELECT AccountId FROM Contact WHERE LastName = 'TestContact' AND AccountId != null GROUP BY AccountId
@sanammulla Жыл бұрын
SELECT AccountId, (SELECT LastName FROM Contacts WHERE LastName Like '%test Contact') FROM Account Ground By AccountId);
@Pushkar682 Жыл бұрын
Do we need group by here?
@rockingrafi.6915 Жыл бұрын
Select id from Account where Id IN (Select AccountId from Contact where LastName Like 'Test%')
@rebajitchannel6065 Жыл бұрын
parent child query
@hemantghaturkar8595 Жыл бұрын
Select id , name , (id from contact) from account where name='test')
@arnabmukherjee9679 Жыл бұрын
Select Account.Name from Contact where lastname = 'test contact' group by Account.Name
@satyam9515 Жыл бұрын
Select ID, name from account where I'd in:(select accountid from contact where lastname ='test contact')
@snehalnagmoti Жыл бұрын
SELECT AccountId FROM Contact WHERE LastName = 'Test Contact' Group By AccountId
@surajbhalerao4449 Жыл бұрын
SELECT Id,name,(SELECT Lastname FROM contacts WHERE Lastname= ' Test contact')FROM Account
@vishal_gadhave Жыл бұрын
Select Account.name from contact where lastName ='test'
@Mtripathi347 Жыл бұрын
Please check other comments as well
@saisubramanyam1999 Жыл бұрын
@@Mtripathi347 Is it correct? Even my solution is same.
@edukondalumareedu3035 Жыл бұрын
@@Mtripathi347 is this query correct?
@mangeshumare3891 Жыл бұрын
Select Id, Name from Account WHERE Id IN ( Select AccountId From contact Where LastName LIKE 'test contact%')
@simmiagrawal6763 Жыл бұрын
SELECT Id, Name FROM Account WHERE Id IN ( SELECT AccountId FROM Contact Where AccountId != NULL AND LastName='test contact')
@RohitYadav-bq9xc Жыл бұрын
[SELECT Id,(SELECT Id, LastName FROM Contacts)FROM Account WHERE LastName ='TestContact ']
@usharavi2325 Жыл бұрын
Select id, Name, (Select id, FirstName, LastName from contacts where LastName='Test Contact') From Account Where id IN(Select AccountId from contact where LastName='Test Contact')
@deepajs5 ай бұрын
Select id,name,(select lastname,Accountid from contacts where lastname=‘Test contact’)from Account