I have the Master & Transaction Database. I am looking for the count of tranascations against the master table. I am getting the result of the transaction count but not the list which doesnt has any records against the master records. Can someone please help me on this.
select a.name, count(*) from DB1.master as a
join DB2.transcation as b
on a.name=b.name
group by a.name