从表中获取数据我应该如何正确查询 [英] fetch data from tables how should be my correct query

问题描述

SELECT * FROM TableC
         INNER JOIN TableB ON TableB.mid=TableC.mid
         INNER JOIN TableA ON TableA.userid=(
                                             SELECT distinct userid 
                                               FROM TableB)

子查询返回了1个以上的值.

Subquery returned more than 1 value.

**Medical_Master**

           MedicalID MedicalName
           1(pk)     abc
           2         xyx
           3         pqr
           
**Child_Medical_Master**

           ChildMID MedicalID Station Name
           1(pk)    1(fk)     bnb     mfk
           2        1         def     rwr
           3        2         re      wrw      
        
**Medical_Visit**

           VTID  PMID  RFMID age
           1(pk) 2(fk) 1      34
           2     2     3      45
           3     3     1      45
           4     1     2      44
           5     2     2      76
           
**Medical_Study**

           UID   VTID  ChildMID SMID   Date  time 
           1(pk) 1(fk) 1        1      kk    jdj
           2     2     3        2      kdf   lfl
           6     3     2        3      rgr   rtr
    
**Doctor_Master**

           RFMID  Doctorname
           1(pk)  mr.john
           2      mr.jack
           3      mr.jim
           
**PAtient_Master**

           PMID   Firstname LastNAme
           1(pk)  df         ere
           2      rwe        rwer
           3      rwr        fwr
           
**Study_Master**

           SMID   MedicalID Description Duration
           1(pk)  1(fk)     fdf         efe
           2      1         ddf         dfdf
           3      2         df          ef

我希望表格中的这些列如何正确查询?

UID，PMID，FIRSTNAME，LASTNAME，AGE，MEDICALNAME，DESCRIPTION，STATION，DATE，DoctorName

I want these columns from tables how should be my correct query?

UID,PMID,FIRSTNAME,LASTNAME,AGE,MEDICALNAME,DESCRIPTION,STATION,DATE,DoctorName

推荐答案

尝试:

SELECT * FROM TableC
INNER JOIN TableB ON TableB.mid=TableC.mid
INNER JOIN TableA ON TableA.userid IN (
SELECT DISTINCT userid
FROM TableB)

尝试一下.

Try this.

select Ms.Uid, MV.PMID, Pm.FirstName,Pm.LastName,Mv.Age,MM.MedicalName,SM.Description, CMM.Station,Ms.Date, DM.Doctorname
from Medical_Study MS
inner join Medical_Visit MV
on MS.UID = MV.uid
inner join PAtient_Master PM
on   MV.PMID  =  PM.PMID 
inner join Study_Master SM
on MS.SMID= SM.SMID
inner join Medical_Master MM
on Sm.MedicalId = MM.MedicalID
inner join Child_Medical_Master CMM
on Sm.MedicalId= CMM.MedicalId
inner join Doctor_Master DM
on Mv.RFMID = Dm.RFMID

select [UID],PM.PMID,Firstname,lastname,MV.Age,MedicalName,[Description],station,[date],doctorname
from
Medical_Study MS
inner join Medical_Visit MV on MV.VTID=MS.VTID
inner join PAtient_Master PM on PM.PMID=MV.PMID
inner join Doctor_Master DM on DM.RFMID=MV.RFMID
inner join Child_Medical_Master CMM on CMM.ChildMID=MS.ChildMID
inner join Medical_Master MM on MM.MedicalId=CMM.MedicalId
inner join Study_Master SM on MS.SMID=SM.SMID

这篇关于从表中获取数据我应该如何正确查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！