多表查询问题，请求帮助【急】！

Question

各位大哥大姐大叔大妈大大 大家好！
小弟弟我有一个问题请教。关于多表联查的问题。现有表
INHOspital_patient_base
INHOspital_patient_Ext
Mem_ID
Mem_AC
ZY_Bed_InfoMationINHOspital_patient_base表里面要查询出来的字段  [ID]，SerialNo，EnjoyKind，InDate
INHOspital_patient_Ext表里面要查询出来的字段 In_Ac
Mem_ID表里面要查询出来的字段 Idcode，Name字段，Sex，birthday
Mem_AC表里面要查询出来的字段 Balance，Total
ZY_Bed_InfoMation表里面要查询出来的字段 BQBH，KSMC，CWBH
INHOspital_patient_base的[ID]字段 和 INHOspital_patient_Ext里[Mem_ID]字段 有关联
INHOspital_patient_base的[ID]字段 和 Mem_ID里[ID]字段 有关联
INHOspital_patient_Ext表查出的In_Ac字段 和 Mem_AC里[In_Ac]  有关联
INHOspital_patient_base的[ID]字段 和 ZY_Bed_InfoMation[BAH] 有关联条件是INHOspital_patient_base [ID] = '000000000160' AND State != 1 大家帮帮忙。
 

Answer 1

select
  a. [ID],a.SerialNo,a.EnjoyKind,a.InDate,b.In_Ac,
  c.Idcode,c.Name字段,c.Sex,c.birthday,
  d.Balance,d.Total,
  e.BQBH,e.KSMC,e.CWBH
from
  INHOspital_patient_base a,
  INHOspital_patient_Ext b,
  Mem_ID c,
  Mem_AC d,
  ZY_Bed_InfoMation e
where
  a.[ID]=b.Mem_ID
and
  a.ID=c.ID
and
  b.In_Ac=d.In_Ac
and
  a.id=e.BAH
and
  a.[ID] = '000000000160' AND a.State != 1

Answer 2

select * from INHOspital_patient_base a
 left join INHOspital_patient_Ext b on a.id=b.[Mem_ID]
 left join Mem_ID c on a.id=c.id
 left join Mem_AC d on b.In_Ac=d.In_Ac
 left join ZY_Bed_InfoMation e on a.id=e.BAH
where a.id='000000000160' and a.State<>1