|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 |
CREATE TABLE #A (Author Varchar(20), Location Varchar(20)) INSERT INTO #A(Author,Location) VALUES ('Job', 'NY' ), ('Jim', 'MD' ), ('Job', 'NY' ), (NULL , NULL ) CREATE TABLE #B (Book Varchar(20),Author Varchar(20)) INSERT INTO #B(Book,Author) VALUES ('A', 'Job' ), ('B', 'Jim' ), ('C', 'Job' ), (NULL, NULL ) SELECT a.Author,b1.book,b2.Book, a.Location FROM #A a JOIN (SELECT Author,MAX(Book) MaxB, MIN(Book) MinB FROM #B GROUP BY Author) b0 ON b0.Author=a.Author JOIN #B b1 ON b1.Author=b0.Author JOIN #B b2 ON b2.Author=b0.Author DROP TABLE #A DROP TABLE #B |
1. Варианты ответов:
