Trying to pull the total Count from 2 different database with some of the same columns
<p>I cant seem to figure our how to join these 2 database together to get  my totals. <code>DBO.Agent</code> has columns <code>agentid</code>, <code>buisnesslineID</code> and <code>TeamID</code>. <code>DBO.Buinessline</code> has Columns <code>ParentbusinsesslineID</code> and <code>BusinessLineID</code>. </p>

<pre><code>SELECT  A.Agentid,A.BusinessLineID,A.TeamID,B.ParentBusinessLineID, Count (*) AS Total
FROM Dbo.BusinessLine AS B LEFT JOIN Dbo.Agent AS A ON A
WHERE 
</code></pre>