@truls46@mastodon.social The problem is the `FROM osupdate AS ou ` part. This does not create an alias `ou` to the table `osupdate` in PostgreSQL but a self-join. Effectively the same table joined with itself. The result is every single `osupdate` row gets 0 for devices_count. MSSQL Server on the other side binds the target and the FROM, no copy. It's my fault using `FROM` in the first place, but yeah - still a lot to be learned about SQL.