WHERE子句出错 [英] Error in WHERE clause

问题描述

我正在做一个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屋！