本文介绍了选择查询的问题的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧! 问题描述 29岁程序员,3月因学历无情被辞! 我有三个表用于图书馆管理系统 tbllibissue IssueID IssueCode IssueDate StaffProfileID StudentProfileID 备注 56 ISC056 2013-02-07 00:00:00 。 000 0 111 re 57 ISC057 2013-02-12 00:00:00 。 000 0 57 asdfsfdsfsd 55 ISC054 2013-02-06 00:00:00 。 000 0 42 xvxvc tbllibissuedetails IssueDetailsID IssueID StockID 数量 ReturnOrRenewalDate Res ervedID 描述 191 57 6 1 2013-02-18 00:00:00 。 000 0 asdfdasf 192 57 4 1 2013-02-18 00:00:00 。 000 0 sdf 193 57 3 1 2013-02-18 00:00:00 。 000 0 asdfsdf tbllibrenewal RenewalID RenewalCode RenewalDate StudentProfileID IssueDetID StockID IsReturned 98 RCO98 2013-02-12 57 191 6 1 99 RC099 2013-02-12 57 192 4 0 在第一个和第二个表中用于在向学生发放书籍时插入记录。第三个表用于在相应的图书返回或续订时插入记录。如果书籍退回,''返回''列将为1,否则续订为0. 我想要上面三张表中的记录不是回 。例如 我想通过studentprofileid获得记录= 57 Issuedetailsid stockid 192 4 193 3 如何获得这个。请帮我解决这个问题解决方案 I have three tables which is used for library management sysytemtbllibissueIssueIDIssueCodeIssueDateStaffProfileIDStudentProfileIDRemarks56ISC0562013-02-07 00:00:00.0000111re57ISC0572013-02-12 00:00:00.000057asdfsfdsfsd55 ISC054 2013-02-06 00:00:00.000 0 42 xvxvctbllibissuedetailsIssueDetailsID IssueID StockID Qty ReturnOrRenewalDate ReservedID Description191 57 6 1 2013-02-18 00:00:00.000 0 asdfdasf192 57 4 1 2013-02-18 00:00:00.000 0 sdf193 57 3 1 2013-02-18 00:00:00.000 0 asdfsdftbllibrenewalRenewalID RenewalCodeRenewalDate StudentProfileID IssueDetIDStockIDIsReturned98RCO98 2013-02-12 57 1916 199 RC099 2013-02-12 57 192 4 0In the first and second table is used to insert the records when book is issued to student. And third table is used to insert the records whenever that corresponding book is return or renewal. If the book is return the ''Isreturned'' column will be 1 otherwise it is renewal it is 0.I want the records from above three tables which is not returned . for exampleI want get the records by studentprofileid=57Issuedetailsid stockid192 4193 3How to get this. Please help me solve this problem 解决方案 这篇关于选择查询的问题的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持! 上岸,阿里云!
08-13 22:19