以下语句除了查询满足条件的记录，还显示（）表的所有记录SELECT Book.*,Borrow.ReaderIDFROM Borrow RIGHT OUTER JOIN BookON Book. BookID =Borrow. BookID
A: Reader
B: Borrow
C: Book
A: Reader
B: Borrow
C: Book
举一反三
- 以下语句除了查询满足条件的记录，还显示（）表的所有记录 SELECT Book.*,Borrow.ReaderID FROM Borrow RIGHT OUTER JOIN Book ON Book. BookID =Borrow. BookID A: Reade B: Borrow C: Book
- 以下语句除了查询满足条件的记录，还显示（）表的所有记录。SELECT Reader.*,Borrow.ReaderIDFROM Reader LEFT OUTER JOIN Borrow ON Reader.ReaderID=Borrow.ReaderID A: Reader B: Borrow C: book
- 下列两个语句select [name] from book where bno in (select bno from borrow)和select [name] from book where exists ( select * from borrow where borrow.bno=book.bno) 查询结果相同。
- 查询被借阅过的图书,语句 SELECT name from book where( ) 的条件,下列哪[br][/br]一个不能实现. A: no =all (select bno from borrow) B: no =any (select bno from borrow) C: no in (select bno from borrow) D: exists (select * from borrow where bno=book.bno)
- 查询被借阅过的图书,语句SELECT name from book where____的条件,下列哪一个不能实现。 A: bno =all (select bno from borrow) B: bno =any (select bno from borrow) C: bno in (select bno from borrow) D: exists t(select * from borrow where bno=book.bno)