从mssql数据库中的四个表中选择记录 [英] selecting records from four tables in mssql database

问题描述

我正在尝试从mssql中的四个不同表中选择SELECT记录。

采石场运行时没有显示结果。这是我使用的采石场

  SELECT  P.Regdate，P .Assemblys，P.Surname，P.Othername，P.Gender，P.Nationality，P.Dateofbirth，P.Residentialaddress，P.Hometownaddress，P.Telephone，P.Email，P.Occupation，P.Maritalstatus，P.Nameofspouse ，P.Mfullname，P.Mlivingstatus，P.Mhometown，P.Ffullname，P.Flivingstatus，P.Fhometown，P.NOKfullname，P.NOKresidence，P.NOKtelephone，C.Communicant，C.Holyspiritbaptism，C.Holyspiritbaptismdate，C .Holyspiritbaptismplace，C.Waterbaptism，C.Waterbaptismdate，C.Waterbaptismplace，C.Waterbaptismminister，C.Positionchurch，C.Cellgroups，M.Ministryname，O.Ministryname 
  from  tblPersonal P，tblChurchdetails C，tblMembershipministry M，tblMembershipotherministry O 
  WHERE  P.FormattedMembershipid = '  ATOM / 000004'  AND  C.Formatt edMembershipid = '  ATOM / 000004'  AND  M.FormattedMembershipid = '  ATOM / 000004'  AND  O.FormattedMembershipid = '  ATOM / 000004' 

请帮帮我

解决方案

你需要一起加入你的桌子。我建议参考 https://dev.mysql.com/doc/refman/5.0上的文档。 /en/join.html [ ^ ]

对四个表使用内连接，并为P.FormattedMembershipid ='ATOM / 000004'

i am trying SELECT records from four different tables in mssql.
the quarry runs put no results is displayed. this is the quarry i used

SELECT P.Regdate, P.Assemblys, P.Surname, P.Othername, P.Gender, P.Nationality, P.Dateofbirth, P.Residentialaddress, P.Hometownaddress, P.Telephone, P.Email, P.Occupation, P.Maritalstatus, P.Nameofspouse, P.Mfullname, P.Mlivingstatus, P.Mhometown, P.Ffullname, P.Flivingstatus, P.Fhometown, P.NOKfullname, P.NOKresidence, P.NOKtelephone, C.Communicant, C.Holyspiritbaptism, C.Holyspiritbaptismdate, C.Holyspiritbaptismplace, C.Waterbaptism, C.Waterbaptismdate, C.Waterbaptismplace, C.Waterbaptismminister, C.Positionchurch, C.Cellgroups, M.Ministryname, O.Ministryname 
from tblPersonal P, tblChurchdetails C, tblMembershipministry M, tblMembershipotherministry O 
WHERE P.FormattedMembershipid= 'ATOM/000004' AND C.FormattedMembershipid= 'ATOM/000004' AND M.FormattedMembershipid= 'ATOM/000004' AND O.FormattedMembershipid= 'ATOM/000004'

please help me out

解决方案

You need to join your tables together. I suggest referring to the documentation at https://dev.mysql.com/doc/refman/5.0/en/join.html[^]

Use inner join for four tables and put a where condition for your P.FormattedMembershipid= 'ATOM/000004'

这篇关于从mssql数据库中的四个表中选择记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！