从3个表中选择mysql中的不同值

debugcn 发表于 Dev

吉辛·瓦吉斯（Jithin Varghese）

我有三个表tbl_first_product，tbl_third_product和tbl_fourth_product。

每个表有size1，size2，size3，size4，size5列。

例如，在 tbl_first_product

id    size1    size2    size3    size4    size5

1      38       40       42       43        44
2      28       30       32       34        40

在 tbl_third_product

id    size1    size2    size3    size4    size5

1      30       32       40        0        0
2      28       30       32       34        0

在 tbl_fourth_product

id    size1    size2    size3    size4    size5

1      20       26       40       44        0
2      28       30       32       34        40

我想合并所有这些表并获得不同的值，并且输出应该是，

20 26 28 30 32 34 38 40 42 43 44

是否有使用mysql和php获取此输出的任何方法。

我尝试了很多。但是没有结果。

提前致谢。

苏宾·查利尔

您可以SELECT DISTINCT从每个字段中执行UNION 。

SELECT DISTINCT value
    FROM
   (SELECT size1 AS value FROM tbl_first_product

    UNION

    SELECT size2 AS value FROM tbl_first_product

    UNION

    SELECT size3 AS value FROM tbl_first_product

    UNION

    SELECT size4 AS value FROM tbl_first_product

    UNION

    SELECT size5 AS value FROM tbl_first_product

    UNION

    SELECT size1 AS value FROM tbl_third_product

    UNION

    SELECT size2 AS value FROM tbl_third_product

    UNION

    SELECT size3 AS value FROM tbl_third_product

    UNION

    SELECT size4 AS value FROM tbl_third_product

    UNION

    SELECT size5 AS value FROM tbl_third_product

    UNION

    SELECT size1 AS value FROM tbl_fourth_product

    UNION

    SELECT size2 AS value FROM tbl_fourth_product

    UNION

    SELECT size3 AS value FROM tbl_fourth_product

    UNION

    SELECT size4 AS value FROM tbl_fourth_product

    UNION

    SELECT size5 AS value FROM tbl_fourth_product) T
    WHERE value <> 0

希望这可以帮助。

本文收集自互联网，转载请注明来源。

如有侵权，请联系[email protected] 删除。