为了账号安全,请及时绑定邮箱和手机立即绑定

语法含义解读

select a.user_name, b.skill, c.skill
from user1 as a inner join user_skills as b on a.id = b.user_id and b.skill = '念经'
inner join user_skills as c on b.user_id = c.user_id and c.skill = '变化'
where b.skill_level > 0 and c.skill_level > 0;


这个语法含义能一步一步解读一下吗

正在回答

2 回答

首先a与b关联产生结果集这个结果集中满足的条件的是技能是念经,然后将这些结果集与c表关联进一步得到技能是变化的结果集,即这个SQL语句是为了得到既有念经技能又有变化技能的取经人

1 回复 有任何疑惑可以回复我~
#1

慕码人2264004 提问者

非常感谢!
2018-04-13 回复 有任何疑惑可以回复我~
https://vk.com/@712781708-92043
https://vk.com/@712781708-92044
https://vk.com/@712781708-92045
https://vk.com/@712781708-92046
https://vk.com/@712781708-92047
https://vk.com/@712781708-92048
https://vk.com/@712781708-92049
https://vk.com/@712781708-92050
https://vk.com/@712781708-92051
https://vk.com/@712781708-92052
https://vk.com/@712781708-92053
https://vk.com/@712781708-92054
https://vk.com/@712781708-92055
https://vk.com/@712781708-92056
https://vk.com/@712781708-92057
https://vk.com/@712781708-92058
https://vk.com/@712781708-92059
https://vk.com/@712781708-92060
https://vk.com/@712781708-92061
https://vk.com/@712781708-92062
https://vk.com/@712781708-92063
https://vk.com/@712781708-92064
https://vk.com/@712781708-92065
https://vk.com/@712781708-92066
https://vk.com/@712781708-92067
https://vk.com/@712781708-92068
https://vk.com/@712781708-92069
https://vk.com/@712781708-92070
https://vk.com/@712781708-92071
https://vk.com/@712781708-92072
https://vk.com/@712781708-92073
https://vk.com/@712781708-92074
https://vk.com/@712781708-92075
https://vk.com/@712781708-92076
https://vk.com/@712781708-92077
https://vk.com/@712781708-92078
https://vk.com/@712781708-92079
https://vk.com/@712781708-92080
https://vk.com/@712781708-92081
https://vk.com/@712781708-92082
https://vk.com/@712781708-92084
https://vk.com/@712781708-92086
https://vk.com/@712781708-92087
https://vk.com/@712781708-92088
https://vk.com/@712781708-92089
https://vk.com/@712781708-92090
https://vk.com/@712781708-92091
https://vk.com/@712781708-92092
https://vk.com/@712781708-92093
https://vk.com/@712781708-92094
https://vk.com/@712781708-92095
https://vk.com/@712781708-92096
https://vk.com/@712781708-92097
https://vk.com/@712781708-92098
https://vk.com/@712781708-92099
https://vk.com/@712781708-92100
https://vk.com/@712781708-92101
https://vk.com/@712781708-92102
https://vk.com/@712781708-92103
https://vk.com/@712781708-92104
https://vk.com/@712781708-92105
https://vk.com/@712781708-88471
https://vk.com/@712781708-88472
https://vk.com/@712781708-88473
https://vk.com/@712781708-88474
https://vk.com/@712781708-88475
https://vk.com/@712781708-88476
https://vk.com/@712781708-88477
https://vk.com/@712781708-88478
https://vk.com/@712781708-88479
https://vk.com/@712781708-88480
https://vk.com/@712781708-88481
https://vk.com/@712781708-88482
https://vk.com/@712781708-88483
https://vk.com/@712781708-88484
https://vk.com/@712781708-88485
https://vk.com/@712781708-88486
https://vk.com/@712781708-88487
https://vk.com/@712781708-88488
https://vk.com/@712781708-88489
https://vk.com/@712781708-88490
https://vk.com/@712781708-88491
https://vk.com/@712781708-88492
https://vk.com/@712781708-88493
https://vk.com/@712781708-88494
https://vk.com/@712781708-88495
https://vk.com/@712781708-88496
https://vk.com/@712781708-88497
https://vk.com/@712781708-88498
https://vk.com/@712781708-88499
https://vk.com/@712781708-88500
https://vk.com/@712781708-88501
https://vk.com/@712781708-88502
https://vk.com/@712781708-88503
https://vk.com/@712781708-88504
https://vk.com/@712781708-88505
https://vk.com/@712781708-88506
https://vk.com/@712781708-88507
https://vk.com/@712781708-88508
https://vk.com/@712781708-88509
https://vk.com/@712781708-88510
https://vk.com/@712781708-88511
https://vk.com/@712781708-88512
https://vk.com/@712781708-88513
https://vk.com/@712781708-88514
https://vk.com/@712781708-88515
https://vk.com/@712781708-88516
https://vk.com/@712781708-88517
https://vk.com/@712781708-88518
https://vk.com/@712781708-88519
https://vk.com/@712781708-88520
https://vk.com/@712781708-88521
https://vk.com/@712781708-88522
https://vk.com/@712781708-88523
https://vk.com/@712781708-88524
https://vk.com/@712781708-88525
https://vk.com/@712781708-88526
https://vk.com/@712781708-88527
https://vk.com/@712781708-88528
https://vk.com/@712781708-88529
https://vk.com/@712781708-88530
https://vk.com/@712781708-88531
https://vk.com/@712781708-88532
https://vk.com/@712781708-88533
https://vk.com/@712781708-88534
https://vk.com/@712781708-88535
https://vk.com/@712781708-88536
https://vk.com/@712781708-88537
https://vk.com/@712781708-88538
https://vk.com/@712781708-88539
https://vk.com/@712781708-88540
https://vk.com/@712781708-88541
https://vk.com/@712781708-88542
https://vk.com/@712781708-88543
https://vk.com/@712781708-88544
https://vk.com/@712781708-88545
https://vk.com/@712781708-88546
https://vk.com/@712781708-88547
https://vk.com/@712781708-88548
https://vk.com/@712781708-88549
https://vk.com/@712781708-88550
https://vk.com/@712781708-88551
https://vk.com/@712781708-88552
https://vk.com/@712781708-88553
https://vk.com/@712781708-88554
https://vk.com/@712781708-88555
https://vk.com/@712781708-88556
https://vk.com/@712781708-88557
https://vk.com/@712781708-88558
https://vk.com/@712781708-88559
https://vk.com/@712781708-88560
https://vk.com/@712781708-88561
https://vk.com/@712781708-88562
https://vk.com/@712781708-88563
https://vk.com/@712781708-88564
https://vk.com/@712781708-88565
https://vk.com/@712781708-88566
https://vk.com/@712781708-88567
https://vk.com/@712781708-88568
https://vk.com/@712781708-88569
https://vk.com/@712781708-88570
https://vk.com/@712781708-88766
https://vk.com/@712781708-88769
https://vk.com/@712781708-88773
https://vk.com/@712781708-88777
https://vk.com/@712781708-88779
https://vk.com/@712781708-88782
https://vk.com/@712781708-88783
https://vk.com/@712781708-88786
https://vk.com/@712781708-88788
https://vk.com/@712781708-88790
https://vk.com/@712781708-88792
https://vk.com/@712781708-88795
https://vk.com/@712781708-88797
https://vk.com/@712781708-88799
https://vk.com/@712781708-88801
https://vk.com/@712781708-88804
https://vk.com/@712781708-88806
https://vk.com/@712781708-88809
https://vk.com/@712781708-88812
https://vk.com/@712781708-88815
https://vk.com/@712781708-88817
https://vk.com/@712781708-88819
https://vk.com/@712781708-88821
https://vk.com/@712781708-88824
https://vk.com/@712781708-88826
https://vk.com/@712781708-88828
https://vk.com/@712781708-88830
https://vk.com/@712781708-88832
https://vk.com/@712781708-88835
https://vk.com/@712781708-88837
https://vk.com/@712781708-88840
https://vk.com/@712781708-88842
https://vk.com/@712781708-88844
https://vk.com/@712781708-88846
https://vk.com/@712781708-88849
https://vk.com/@712781708-88851
https://vk.com/@712781708-88853
https://vk.com/@712781708-88855
https://vk.com/@712781708-88857


0 回复 有任何疑惑可以回复我~

举报

0/150
提交
取消

语法含义解读

我要回答 关注问题
意见反馈 帮助中心 APP下载
官方微信