大家晚上好,我有一个大问题,因为如果我做得不对。由于我担心这个查询没有向我提供正确的信息。我有两个数据库,"indvalid_hya"answers"uuid_sap"
在我的数据库"indvalid_hya"中,我有以下带有以下字段的表:此表有一个主键"XML_ID",它与ID my表"FILE"相关
+------------+-------+-----------+-------------+------+-------+------------+
| ISSUEDDATE | TOTAL | ISSUERRFC | RECEIVERRFC | UUID | FOLIO | XML_ID (PK)|
+------------+-------+-----------+-------------+------+-------+------------+
| | | | | | | |
+------------+-------+-----------+-------------+------+-------+------------+
这是我在同一BD"Indvalid_hya"中的另一张表"DOCUMENT":
+------------+--------------+-----------+
| ID (FK) | BYTES | ISSUERRFC |
+------------+--------------+-----------+
| | | |
+------------+--------------+-----------+
最后,我有了另一个数据库,名为"uuid_sap"。我在那里有3个老板,他用"ID"联系了另外2张桌子
表"DATOS_SAP":
+----------------+---------+-----------+
| UUID_SAP (FK) | NUM_DOC | SOCIETY |
+----------------+---------+-----------+
| | | |
+----------------+---------+-----------+
这是我的代码,它将我的表"DOCUMENT"answers"FILE"我的BD"Indvalid_hya"与我的另一个BD"uuid_sap"我的表"DATOS_sap""绑定
我的代码MySQL:
SELECT IH.ISSUEDDATE, IH.TOTAL, IH.ISSUERRFC, IH.RECEIVERRFC, IH.UUID, IH.FOLIO, F.BYTES, US.UUID_SAP
FROM indvalid_hya.DOCUMENT IH
INNER JOIN FILE F
ON IH.XML_ID = F.ID
INNER JOIN uuid_sap.DATOS_SAP US
ON IH.UUID = US.UUID_SAP
这是解决方案,如果我错了,请告诉我这里你知道
SELECT DB1_T1.ISSUEDDATE, DB1_T1.TOTAL, DB1_T1.ISSUERRFC, DB1_T1.RECEIVERRFC, DB1_T1.UUID, DB1_T1.FOLIO, DB2_T1.UUID_SAP
FROM indvalid_hya.DOCUMENT DB1_T1
INNER JOIN indvalid_hya.FILE DB1_T2
ON DB1_T1.XML_ID = DB1_T2.ID
INNER JOIN uuid_sap.DATOS_SAP DB2_T1
ON DB1_T1.UUID = DB2_T1.UUID_SAP