SELECT student.name
FROM student
WHERE student.email = copy.owner AND copy.book = "978-0262033848"
OR 拷貝.書籍
SELECT student.name
FROM student
WHERE student.email = loan.borrower AND loan.book = "978-0262033848" 。
在這段代碼中，我試圖結合兩個查詢。它顯示了一個錯誤，我想知道這樣使用它的錯誤是什么
。uj5u.com熱心網友回復：
我最好的猜測是這樣做是你想要的：
我最好的猜測是這樣做是你想要的。
SELECT s.name
FROM student s
WHERE EXISTS (SELECT 1)
FROM copy c
WHERE c.email = c.owner and c.book= '978-0262033848'
) OR
EXISTS (SELECT 1)
FROM貸款l
WHERE s.email = l.borrower and l.book = '978-0262033848')
);
這將選擇在loan或copy表中有指定書籍的學生。
轉載請註明出處，本文鏈接：https://www.uj5u.com/qiye/309797.html
標籤：