有关SQL语法--外联接(高分紧急求援)(200分)

Select Author.name,Count(Book.bookID) as BkCount
from Author Left Outer Join Book on Author.AuthorID=Book.AuthorID
where book.dtPublish>'2002-3-1'
group by Author.name
运行以上SQL语句,发现不能取得表Author中所有的记录.Count(Book.BookID)为零的记录无法在结果中列出.
但去掉了其中的WHERE子句后又变正常了.
请教如何改正?

Select Author.name,Count(Book.bookID) as BkCount
from Author Left Outer Join Book on Author.AuthorID=Book.AuthorID
AND book.dtPublish>'2002-3-1'
group by Author.name

你的条件中的2002-3-1是日期，它应该是字符类型的，book.dtPublish也应该是字符类型的。你的条件设置有问题，book.dtPublish字段不能和字符类型的比较大小。

Thanks,kele6666.