How Can I Use Union Or Union All In My Code

Question

1.00/5 (1 vote)

See more:

i have 4 tables

TABLE: CHECK

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

TABLE: CHECK_VOUCHER

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

TABLE: OFFICIAL_RECEIPT

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

TABLE: PASSBOOK

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

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

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

Posted 8-Jun-14 21:40pm

Member 9663328

Updated 8-Jun-14 22:21pm

Nelek

v2

Add a Solution

Comments

Nayan Rudani 9-Jun-14 4:46am

Please let me know ,Which table is master Table AND foreign key for all Other table To make Join.

Member 9663328 9-Jun-14 4:51am

i don't have a master table, my primary key is the id. i don't have foreign key

Nayan Rudani 9-Jun-14 5:59am

then try with :

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'

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

PRAKASH9 · Answer 1 · 2014-06-08T23:09:00

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'