SQLTeam.com | Weblogs | Forums

Need SQL Query for Audittrail count against Master Table

Transact-SQL
#1

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

#2

Try a LEFT JOIN.

#3

Thanks Jeff it worked.

#4

Glad it worked. Thank you for the feedback.