Sorry to bother you all again.
Im trying to join these two queries together, can you help.
I need all the accounts in query one and a count of meetings that have have taken place which are in query two... I know i need to join on accountName but am unsure how to join the 2 queies
Select AccountName
From dbo.Sales
Group By AccountName
Select AccountName, ISNULL(Count(AccountAccount),0) As NumberOFMeeting
From dbo.V_Time
Group by AccountName
Im trying to join these two queries together, can you help.
I need all the accounts in query one and a count of meetings that have have taken place which are in query two... I know i need to join on accountName but am unsure how to join the 2 queies
Select AccountName
From dbo.Sales
Group By AccountName
Select AccountName, ISNULL(Count(AccountAccount),0) As NumberOFMeeting
From dbo.V_Time
Group by AccountName