SQL Magic

crossDatabaseBookCounting.sql

SELECT a.Id, COUNT(b.Title) AS BookCount FROM BooksDB.dbo.Books AS b JOIN BooksDB.dbo.Authors AS a ON b.AuthorId = a.Id GROUP BY a.Id


UPDATE BooksDB.dbo.Fun SET Value = (SELECT COUNT(b.Title) AS BookCount FROM BooksDB.dbo.Books AS b JOIN BooksDB.dbo.Authors AS a ON b.AuthorId = a.Id GROUP BY a.Id)


ID AUTORA	LICZBA_KSIĄŻEK (ZLICZONA W QUERY) AS LQ 	LICZBA_KSIĄŻEK (ZAPISANA W TABELI) AS LT
-------------------------------------------------
		JOIN STATS ON LT.ID = LQ.ID	
---------------------------------------------
UPDATE STATS SET VALUE = LICZBA_KSIĄŻEK