Joining two tables using a count
- by Dave
I have two tables as defined below:
EMAILS
ID SUBJECT BODY
1 Test1 blah blah
2 Test2 blah blah blah
3 Test3 more blah
ATTACHMENTS
ID EMAIL_ID ATTACHMENT NAME
1 2 TEST.DOC
2 2 TEST.XLS
I'm trying to perform a select to get back all of the emails and a count of how many…