以下语句除了查询满足条件的记录，还显示（）表的所有记录。SELECT Reader.*,Borrow.ReaderIDFROM Reader LEFT OUTER JOIN Borrow ON Reader.ReaderID=Borrow.ReaderID
A: Reader
B: Borrow
C: book
A: Reader
B: Borrow
C: book
举一反三
- 以下语句除了查询满足条件的记录，还显示（）表的所有记录SELECT Book.*,Borrow.ReaderIDFROM Borrow RIGHT OUTER JOIN BookON Book. BookID =Borrow. BookID 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.*,RID,BID Borrow FULL OUTER JOIN Reader ON eader.RID=Borrow.RID
- 智慧职教: 创建视图，保存所有借书逾期者名单。代码如下:create overduelistasselect reader.readerID,reader.name from reader where readerID (select from borrow where rtndate null and eprdate
- 智慧职教: 更新borrow表每条借书记录的eprdate(到期日期)。 borrow eprdate=timestampadd(day,(select maxdays from readertype where typeID in (select typeID from reader where reader.readerID=.)),brwdate);