Union Select不显示Union结果

Question

嘿，伙计们，当我指定我的main select列名时，我的查询没有返回联合结果，也就是

SELECT inspection_number, region, report_date, 
inspection_type AS type, customer, customer_number, shipper, po
FROM reports
JOIN (
    (

        SELECT `key`, `report_key`, `shipper`, `po`, `commodity`, `label`, `status`
        FROM `berries`
    )
    UNION (

        SELECT `key`, `report_key`, `shipper`, `po`, `commodity`, `label`, `status`
        FROM `melons`
    )
    UNION (

        SELECT `key`, `report_key`, `shipper`, `po`, `commodity`, `label`, `status`
        FROM `citrus`
    )
    UNION (

        SELECT `key`, `report_key`, `shipper`, `po`, `commodity`, `label`, `status`
        FROM `table_grapes`
    )
    UNION (

        SELECT `key`, `report_key`, `shipper`, `po`, `commodity`, `label`, `status`
        FROM `tree_fruit`
    )
    UNION (

        SELECT `key`, `report_key`, `shipper`, `po`, `commodity`, `label`, `status`
        FROM `lot`
    )
) fruits ON inspection_number = fruits.report_key
WHERE fruits.status = '0' OR fruits.status = '1'
ORDER BY report_date DESC

不返回key、report_key、shipper、po、commodity、label或status

奇怪的运行

SELECT *
inspection_type AS type, customer, customer_number, shipper, po
FROM reports
JOIN ( -- etc.....

将要?我该如何解决这个问题呢？

Answer 1

fruits派生表确实有提到的列，但在主选择中没有提到它们中的任何列；您只从报表中提到了列inspection_number、region、report_date和inspection_type -因此它只显示它们。

如果要包括fruits列，则需要在主select语句中指定它们

例如，类似于：

SELECT inspection_number, region, report_date, 
inspection_type, key, report_key, shipper, po, commodity, label, status AS type, customer, customer_number, shipper, po, key, report_key, shipper, po, commodity, label, status
FROM reports
JOIN (