请教一般连接与内连接的异同
例如这两条语句
有什么不同啊
这样的查询可以称作内连接
SELECT P.PublisherCode, P.PublisherName, B.BookCode, B.BookTitle
FROM Publisher P LEFT INNER JOIN Book B
ON P.PublisherCode = B.PublisherCode
how this is different to:
这样的查询又应该成为什么呢??
SELECT P.PublisherCode, P.PublisherName, B.BookCode, B.BookTitle
FROM Publisher P, Book B
WHERE P.PublisherCode = B.PublisherCode
大虾指教啊