mysql - 如何将这两个查询与每个查询中的多个联接连接在一起？

Question

所以我有两个查询需要在 word_pdf_cords.lineNumber 上加入。这两个查询本身也包含联接。不知道 MySQL 的语法，所以我有点挣扎。

查询一

Select pdf.html_path,pdf.xml_path, 
word.word_Value,word_pdf.word_pdf_ID,word_pdf_cords.word_pdf_cords_ID,
word_pdf_cords.word_pdf_ID,word_pdf_cords.pageNumber,
word_pdf_cords.lineNumber 

FROM word_pdf

INNER JOIN pdf ON pdf.PDF_ID = word_pdf.PDF_ID

Inner Join word ON word.word_ID = word_pdf.word_ID

Inner Join word_pdf_cords ON word_pdf.word_pdf_ID = 
word_pdf_cords.word_pdf_ID

WHERE word.word_Value ="clocks"

查询二

Select pdf.html_path,pdf.xml_path, 
word.word_Value,word_pdf.word_pdf_ID,word_pdf_cords.word_pdf_cords_ID,
word_pdf_cords.word_pdf_ID,word_pdf_cords.pageNumber,
word_pdf_cords.lineNumber 

FROM word_pdf

INNER JOIN pdf ON pdf.PDF_ID = word_pdf.PDF_ID

Inner Join word ON word.word_ID = word_pdf.word_ID

Inner Join word_pdf_cords ON word_pdf.word_pdf_ID = 
word_pdf_cords.word_pdf_ID

WHERE word.word_Value ="pirates"

我需要在 pdf_cords.lineNumber 上加入这两个查询的结果。

Answer 1

据我所知，唯一的区别在于 WHERE 子句，因此您可以仅连接 where 子句，而不是连接两个查询:

WHERE word.word_Value ="pirates" OR word.word_Value ="clocks"