编写SQL Server Querry [英] writing sql server querry

问题描述

大家好！

在这里，我很难写出《 Querry》.

你能帮我写奎莉吗?

我有三个表T1，T2，T3

T1有字段
u/id和mrf/id

T2有字段
mrf/id和m/id

T3有字段
m/id和m/name


给定我有u/id，我必须获得m/name

hi to all!

here i find difficult to write a querry

can u help me to write that querry

i have three tables T1, T2, T3

T1 has fields
u/id and mrf/id

T2 has fields
mrf/id and m/id

T3 has fields
m/id and m/name


given i have u/id and i have to get m/name

推荐答案

select mid
from T3
inner join T2 on T3.mid = T2.mid
inner join T1 on T1.mrfid = T2.mrfid and T1.uid = @uid

在这里

select mname from T3 where mid in(select mid from T2 where mrfid in(select mrfid from T1 where uid=@uid))

这篇关于编写SQL Server Querry的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！