Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT m.id,
- m.created,
- m.attr2,
- SUM (d.Status) as CountOfStatusOnes, //Ha szummázod a statuszokat, akor az összeg pont annyi lesz, ahány egyes van :)
- COUNT(d.Status) - SUM(s.Statusz) as CountOfStatusZeros //EZ meg a nullás
- FROM Master m,
- LEFT JOIN Detail d ON m.id=d.masterFk
- WHERE created > GETDATE() - 100
- GROUP BY m.id
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement