combine two tables data

Question

0.00/5 (No votes)

See more:

i want to display data from two tables in which display all data from first table and one one filed from second table so which query i will use... and there is no common field
Plz Reply

Posted 27-Apr-12 20:31pm

Mits Machhi

Updated 27-Apr-12 20:33pm

Mehdi Gholam

v3

Add a Solution

Comments

OriginalGriff 28-Apr-12 3:03am

If there is no common field, how do you expect us to be able to help you write a query?
We have no idea what your data looks like, or what results you expect to get.
Try giving us an example of your data inputs, and what you want as data output. Then we may be able to help.
Use the "Improve question" widget to edit your question and provide better information.

2 solutions

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)

Ashish Bhujbal · Answer 1 · 2012-04-27T20:59:00

Solution 1

Simplest way is: use hash table

1> Create hash table with requred field
2> Insert data from first table to this hash table.
3> Then using while loop, update this hash table with column from second table.
4> Finaly select from hash table.

Posted 27-Apr-12 20:59pm

Ashish Bhujbal

Mehdi Gholam · Answer 2 · 2012-04-27T21:03:00

Unless there is some commonality between the data tables then this will not work and does not make sense, you are better off showing two tables one after another.

If there is commonalty you can use :

SQL

select c1 as 'x',c2 as 'y' from table1
union 
select d1 as 'x', d2 as 'y' from table2

where c1, c2 are the column names from table1 and d1 and d2 from table2, 'x' and 'y' is the name for the columns in your query.