MySQL - 使用需要从同一个表进行查找的不同值构建查询

Question

这是我的查询:

 SELECT f.pending
      , f.title
      , f.funeraltype
      , f.firstname
      , f.middlename
      , f.lastname
      , f.suffix
      , f.displayage
      , f.age
      , f.displaycity
      , f.city
      , f.displaydate
      , f.date
      , f.aftersunset
      , f.funeraldate
      , f.displayfuneraldate
      , f.ftime
      , f.displayservicelocation
      , l.location
      , f.displaycemetery
      , c.name
      , f.displayobituary
      , f.obituary
      , f.displaycharity1
      , ch.name
      , f.charity1memo
      , f.displaycharity2
      , f.charity2
      , f.charity2memo
      , f.displaycharity3
      , f.charity3
      , f.charity3memo
      , f.displaycharity4
      , f.charity4
      , f.charity4memo
      , f.displaycharity5
      , f.charity5
      , f.charity5memo
      , f.memorialbook
      , f.displayshiva
      , f.displaytime
      , f.shivaendpart
      , f.shivauntil
      , f.shivaatresidence
      , f.shivaname
      , f.shivaaddress
      , f.shivacity
      , f.shivastate
      , f.shivazip
      , f.shivaphone
      , f.shivacomment
      , f.displayfamilymembers
      , f.familymembers
      , f.displayclergy
      , f.clergy
      , f.livevideo
      , f.archivevideo
      , f.video
      , f.usemp4video
      , f.mp4video
      , f.custom_text
      , f.charities_footnote
      , f.charity1note
      , f.charity2note
      , f.charity3note
      , f.charity4note
      , f.charity5note
   FROM funerals f
      , locations l
      , cemeteries c
      , charities ch
  WHERE f.servicelocation = l.locationid 
    AND f.cemetery = c.cemeteryID 
    AND f.charity1 = ch.CharityID 
    AND f.charity2 = ch.CharityID 
    AND f.charity3 = ch.CharityID 
    AND f.charity4 = ch.CharityID 
    AND f.charity5 = ch.CharityID

ch.name 是我想要提取的内容。 f.charity1、f.charity2、f.charity3、f.charity4 和 f.charity5 都包含需要在“慈善机构”表中查找的不同 ID。我将如何构造此查询以显示每个慈善机构名称？

Answer 1

 SELECT f.pending
      , l.location
      , f.displaycemetery
      , c.name
      , f.displaycharity1
      , ch.name
      , f.charity1memo
      , f.displaycharity2
      , f.charity2
      , f.charity2memo
      , f.displaycharity3
      , f.charity3
      , f.charity3memo
      , f.displaycharity4
      , f.charity4
      , f.charity4memo
      , f.displaycharity5
      , f.charity5
      , f.charity5memo
      , f.charity1note
      , f.charity2note
      , f.charity3note
      , f.charity4note
      , f.charity5note
   FROM funerals f
   JOIN locations l
     ON l.locationid = f.servicelocation
   JOIN cemeteries c
     ON c.cemeteryID = f.cemetery   
   JOIN charities ch1
     ON ch1.CharityID = f.charity1
   JOIN charities ch2 
     ON ch2.CharityID = f.charity2 
    etc.