如何在我的代码中使用Union或Union All [英] How Can I Use Union Or Union All In My Code

问题描述

我有4张桌子



表：CHECK

i have 4 tables

TABLE: CHECK

ID  |  CHECK_NO  |  INPUTBY
1   |  123       |  NINA
2   |  234       |  IAN

表：CHECK_VOUCHER

TABLE: CHECK_VOUCHER

ID |   CV_NO   |     INPUTBY
1  |   4515    |     NINA
2  |   2349    |     IAN

表：OFFICIAL_RECEIPT

TABLE: OFFICIAL_RECEIPT

ID |   OR_NO   | INPUTBY
1  |  12393A   |  NINA
2  |  23441A   |   IAN

表：PASSBOOK

TABLE: PASSBOOK

ID  |  ACCOUNT_NO  |  INPUTBY
1   |  84823       |  NINA
2   |  74159       |  IAN

我想要我的DATAGRIDVIEW就好了这个

I WANT MY DATAGRIDVIEW TO BE LIKE THIS

INPUTBY  |   DOCUMENT        | NO
NINA     |   CHECK           | 123
NINA     |   CHECK_VOUCHER   | 4515
NINA     |   OFFICIAL_RECEIPT| 12393A
NINA     |   PASSBOOK        | 84823

我是否可能使用UNION或UNION ALL CODE ???

IS IT POSSIBLE IF I USE A UNION OR UNION ALL CODE???

推荐答案

你可以使用如下的联合

You can use union like following

SELECT INPUTBY,'CHECK' AS DOCUMENT,CHECK_NO AS NO FROM CHECK WHERE INPUTBY = 'NINA'

UNION

SELECT INPUTBY,'CHECK_VOUCHER' AS DOCUMENT,CV_NO AS NO FROM CHECK_VOUCHER WHERE INPUTBY = 'NINA'

UNION

SELECT INPUTBY,'OFFICIAL_RECEIPT' AS DOCUMENT,OR_NO AS NO FROM OFFICIAL_RECEIPT WHERE INPUTBY = 'NINA'

UNION

SELECT INPUTBY,'PASSBOOK' AS DOCUMENT,ACCOUNT_NO AS NO FROM PASSBOOK WHERE INPUTBY = 'NINA'

这篇关于如何在我的代码中使用Union或Union All的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！