Popular Posts
DataList paging //利用PageDataSource來做分頁功能 PagedDataSource pds = new PagedDataSource(); //將PageDataSource綁定SqlDataSource pds.DataSource = SqlDataSource1.Selec... for xml usage SELECT p.[product_name], p.[product_imgstyle], p.[product_color], p.[product_size], p.[product_weight], p.[product_desc], ( SELECT l.[purch... Build an OpenVPN server on android device Preparation An android device, in this case, Sony xperia Z is used Root permission required Linux Deploy for deploy i...
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