SELECT t1.run
,ISNULL((SELECT COUNT(t2.errors) FROM table2 t2 WHERE t2.run = t1.run ), 0) as errors
FROM table1 t1
- Comment
- Reblog
-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
SELECT t1.run
,ISNULL((SELECT COUNT(t2.errors) FROM table2 t2 WHERE t2.run = t1.run ), 0) as errors
FROM table1 t1
CSharpWiki 
Leave a comment