query to multiple tables to get same column name VoucherNo in single column from both tables

Question

0.00/5 (No votes)

See more:

Hi All,

Using Two Table
1. tbl_Cash for Cash Accounts
2. tbl_Bank for Bank Accounts

Both tables using 2 different columns having same name VoucherNo. but value is diffrent like that

For Cash VoucherNo. CB/P/201210160001
For Bank VoucherNo. BB/R/201210160001

There is a grid where column VoucherNo. should show both upper VoucherNo's Like that

ID || VocuherNo || Date || AccountName
---------------------------------------
---------------------------------------
01 CB/P/201210160001 10/15/2012 Cash
02 BB/R/201210160001 10/15/2012 Bank

How can i query in database to get VoucherNo in single column from both tables?

Please advice

Thanks,

Posted 15-Oct-12 19:36pm

Afzal Shaikh

Add a Solution

Comments

[no name] 16-Oct-12 1:38am

U have any primary key for the table..???

damodara naidu betha 16-Oct-12 1:40am

Is there any relation ship between the two tables?

Afzal Shaikh 16-Oct-12 1:42am

No , Both are different transaction tables.
Yes ,there is CompanyID in Both tables which is not unique and primary key.

2 solutions

Solution 2

A union All like shown below may help.

SQL

select VoucherNo as vNo from tbl_Cash
union all
select VoucherNo as vNo from tbl_Bank

Hope that helps, If it does mark it as answer/upvote
Thanks,
Milind

Posted 15-Oct-12 19:58pm

MT_

Comments

Afzal Shaikh 16-Oct-12 2:04am

It works :)

Afzal Shaikh 16-Oct-12 2:08am

order by is not working in with union all so better is solution 1

MT_ 16-Oct-12 2:09am

No problem. what is important is that you are able to move ahead. - Milind

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)

Afzal Shaikh · Accepted Answer · 2012-10-15T19:52:00

Solution 1

Solved Myself :)

SQL

SELECT VoucherNo into #A FROM tbl_Bank

Insert into #A
Select VoucherNo from tbl_Cash

Select VoucherNo from #A

Posted 15-Oct-12 19:52pm

Afzal Shaikh

Comments

MT_ 16-Oct-12 2:01am

Having union as shown below will save a temporary table for you.