Om customers endast kommer returnera en rad så bör ju denna fungera:
Kod:
SELECT c.*, (SELECT COUNT(*) FROM Followers AS f WHERE f.accountNo = c.accountNo) AS followers FROM Customer c INNER JOIN OptInChannels o ON c.accountNo=o.accountNo WHERE c.accountNo = '907286609046'