Popular Posts
Add file to google drive using Google.Apis.Auth.OAuth2; using Google.Apis.Drive.v2; using Google.Apis.Drive.v2.Data; using Google.Apis.Services; using Google.Apis.Ut... Enable SSL connection for Jsoup import org.jsoup.Connection; import org.jsoup.Jsoup; import javax.net.ssl.*; import java.io.IOException; import java.security.KeyManagement... JavaMail sample import java.io.File; import java.io.UnsupportedEncodingException; import java.util.Date; import java.util.Properties; import javax.activati...
Blog Archive
Stats
Join related table and count rows or sum
sql server 2005
count rows:
SELECT * FROM Table1
LEFT JOIN
    (SELECT Level1ID, COUNT(Level2ID) AS Total FROM Table2 GROUP BY Level1ID) AS RelatedTable
ON
    Table1.Level1ID = RelatedTable.Level1ID
WHERE
    SomeColumn = Something
count sum:
SELECT * FROM Table1
LEFT JOIN
    (SELECT Level1ID, SUM(Bonus) AS TotalBonus FROM Table2 GROUP BY Level1ID) AS RelatedTable
ON
    Table1.Level1ID = RelatedTable.Level1ID
WHERE
    SomeColumn = Something