好的,我有四个表:
表1:"f_withholdings"
表2:"f_wh_list"
表3:"f_rpayments"
表4:"f_rp_list"
如图片所示,表1和表2通过wh_id
字段相连,表3和表4通过rp_id
相连。
我想将这两个表联合选择成一个表,类似于以下内容:
SELECT
`wh_list_id`,
`wh_name` AS `name`,
`wh_list_date` AS `date`,
`wh_list_amount` AS `amount`,
`wh_list_pending` AS `pending`,
`wh_list_comment` AS `comment`
FROM
`f_wh_list` LEFT JOIN `f_withholdings` ON `f_wh_list`.`wh_id` = `f_withholdings`.`wh_id`
UNION ALL
SELECT
`rp_list_id`,
`rp_name` AS `name`,
`rp_list_date` AS `date`,
`rp_list_amount` AS `amount`,
`rp_list_pending` AS `pending`,
`rp_list_comment` AS `comment`
FROM `f_rp_list` LEFT JOIN `f_rpayments` ON `f_rp_list`.`rp_id` = `f_rpayments`.`rp_id`
我得到了以下结果:
在结果表中,只有第一个SELECT语句中的一个id字段wh_list_id
,但没有rp_list_id
我希望在结果表中同时拥有这两个id,类似下面这样:
谢谢!