php - MySQL从表中选择数据并内部联接来自另外两个相同表的所有选择

首先，我有两个表，并通过以下查询进行联接

选择o5.id AS ID，
DATE_FORMAT（o5.vreme_isplata，'％d。％m。％Y'）作为付款日期，
o5.ime_prezime AS名称，
o5.adresa AS地址，
o5.mesto AS城市，
o5.embg AS mb，
o5.serial_no AS票证，
o1.uplata AS uplata，
o5.pdd AS danok，
o5.isplata AS neto_dobivka，
o1.iznos_isplaten AS bruto_dobivka
从o5开始
内联接o1
开启o5.serial_no = o1.serial_no
在哪里o1.transaction_type ='I'


和它的工作很好
现在我需要从另一个表“ o1_payout_storno”中选择数据。女巫与o1相同
我需要从o5和INNER JOIN选择数据，从UNION ALL和o1选择o1_payout_storno。

最佳答案

应该像这样：

SELECT
  o5.id AS id,
  DATE_FORMAT(o5.vreme_isplata, '%d.%m.%Y') AS payed_date,
  o5.ime_prezime AS name,
  o5.adresa AS address,
  o5.mesto AS city,
  o5.embg AS mb,
  o5.serial_no AS ticket,
  o1.uplata AS uplata,
  o5.pdd AS danok,
  o5.isplata AS neto_dobivka,
  o1.iznos_isplaten AS bruto_dobivka
FROM o5
INNER JOIN o1 ON o5.serial_no = o1.serial_no
WHERE o1.transaction_type = 'I'
UNION ALL
SELECT
  o5.id AS id,
  DATE_FORMAT(o5.vreme_isplata, '%d.%m.%Y') AS payed_date,
  o5.ime_prezime AS name,
  o5.adresa AS address,
  o5.mesto AS city,
  o5.embg AS mb,
  o5.serial_no AS ticket,
  op.uplata AS uplata,
  o5.pdd AS danok,
  o5.isplata AS neto_dobivka,
  op.iznos_isplaten AS bruto_dobivka
FROM o5
INNER JOIN o1_payout_storno AS op ON op.serial_no = o5.serial_no

关于php - MySQL从表中选择数据并内部联接来自另外两个相同表的所有选择，我们在Stack Overflow上找到一个类似的问题：https://stackoverflow.com/questions/27546949/