如何从sql server中的select跳过recodrs [英] How to skip recodrs from select in sql server
问题描述
我有3张桌子A,B和C
A
------------- -
aId bId名字等等.....
101 201 - - -
102 202 - - -
103 203 - - -
104 204
B
------- ------
bId CId Name
201 1 A
202 2 A
203 1 B
204 1 C
C
------------- < br $> b $ b cId值
1 50
2 180
3 10
我想要结果像
A和bID中的所有字段都没有180值我怎么得到它?
使用JOIN链接查询中常见字段的多个表,并使用WHERE过滤结果集(例如,没有180)。
学习 https://technet.microsoft.com/en-us/library/ms191430( v = sql.105).aspx [ ^ ]
试试这个,
选择
a.aid,b.Bid,b。名称
来自 A a,B b,C c
其中 c.value<> 180 和 a.bId = b.Id 和 b.cId = c.Cid
未经测试但这应该有效。
- KR
为此,您应该对 SQL联接非常满意[ ^ ]和 SQL WHERE子句 [ ^ ]。
然后你可以尝试类似的东西:
SELECT A.aId,A.bId,B.Name FROM A INNER JOIN B ON A.bId = B.bId INNER JOIN c ON b.cId = C.cId WHERE C.值<> 180
- Amy
I have 3 table A,B and C
A
--------------
aId bId name place etc.....
101 201 - - -
102 202 - - -
103 203 - - -
104 204
B
-------------
bId CId Name
201 1 A
202 2 A
203 1 B
204 1 C
C
-------------
cId value
1 50
2 180
3 10
I want result like
all field in A and bID which has no 180 value how i get it ?
Use JOIN to link multiple tables on common fields in your query and use WHERE to filter the resultset (e.g. no 180).
Learn https://technet.microsoft.com/en-us/library/ms191430(v=sql.105).aspx[^]
Try this,
select a.aid, b.Bid, b.Name from A a, B b, C c where c.value <> 180 and a.bId = b.Id and b.cId = c.Cid
Haven't tested but this should work.
-KR
To do so, you should be very comfortable with SQL Joins[^] and SQL WHERE Clause[^].
Then you can try something like:
SELECT A.aId,A.bId,B.Name FROM A INNER JOIN B ON A.bId=B.bId INNER JOIN c ON b.cId=C.cId WHERE C.value <> 180
--Amy
这篇关于如何从sql server中的select跳过recodrs的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!