Welcome to
Sign in
|
Help
Search
Home
Blogs
External Feeds
Forums
Photos
Downloads
About Us
»
Romanian Section
»
Intrebari
»
T-SQL
»
Re: extragere date din 2 tabele
Re: extragere date din 2 tabele
08-30-2011, 3:04 PM
B_gd_n[ ]Sahlean
Joined on 07-17-2007
Bucuresti
sysadmin
Re: extragere date din 2 tabele
Reply
Quote
SELECT ... ISNULL(p.BookName,s.BookName) ...
FROM Plan p FULL OUTER JOIN Sales s ON p.BookName = s.BookName
AND p.MonthSales = s.MonthSales
ORDER BY ...
http://msdn.microsoft.com/en-us/library/ms187518.aspx
> secțiunea FULL OUTER JOIN
Report abuse
View Complete Thread