WHERE子句出错 [英] Error in WHERE clause
本文介绍了WHERE子句出错的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我正在做一个sql问题,我输入了一个代码,它显示了一个与Where子句和子查询相关的错误。请有人给我一个解决方案。
我尝试过:
Hi, i am doing a sql question, n i typed out a code, it shows an error which is related to the Where Clause and subqueries. Pls someone give me a solution.
What I have tried:
SELECT B.movie_title AS 'Movie Title',
A.branchID AS 'Branch ID',
C.dvdID AS 'Total_Number_of_DVD'
FROM RENT A
JOIN MOVIE B ON(B.movieID = A.movieID)
JOIN DVD C ON(C.dvdID = A.dvdID)
WHERE A.dvdID IN (SELECT COUNT(A.dvdID) AS 'Total_DVDs_Rented'
WHERE date_returned = NULL) AND A.dvdID IN (SELECT COUNT(C.dvdID - A.dvdID ) AS 'Total DVDs Available'
WHERE date_returned = NULL)
AND movie_title = 'DEADPOOL2';
推荐答案
试试这个:
Try it something this:
SELECT B.movie_title AS [Movie Title],
A.branchID AS [Branch ID],
C.dvdID AS [Total_Number_of_DVD]
FROM RENT AS A
INNER JOIN MOVIE AS B ON B.movieID = A.movieID
INNER JOIN DVD AS C ON C.dvdID = A.dvdID
WHERE A.dvdID IN (SELECT A.dvdID from RENT)
and date_returned = NULL
AND movie_title = 'DEADPOOL2';
CAVEAT:我不知道这是否可行,因为我没有架构或数据可供使用,所以我留给你 - 作为一个sql程序员 - 按摩它以满足你的需要。
CAVEAT: I have no idea if this is gonna work because I don't have schemas or data to work with, so I leave it to you - as a sql programmer - to massage it to fit your needs.
只使用一个where子句和另一个条件使用和/或子句不在哪里...
我们只能使用一个where子句,否则会出现语法错误。
use only one where clause and for another condition use and / or clause not where...
Only One where clause we can use otherwise give syntax error.
这篇关于WHERE子句出错的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文