Fetch Data From Two table in sql server 2005 and 2008

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

Dear Friends

I have two tables t1 and t2.

Table t1 Structure

Paycode
Name

Table t2 Structure

Paycode
Name

And one more thing there is no concept of primary key and foreign key in my table.

Records in t1

1) 111 sunil
2) 222 sunit

Records in t2

1) 333 narayan
2) 444 sumit

and I want all the records from query.............

Please help me out as soon as possible.

Posted 11-May-12 1:58am

Sunil.yadava09

Add a Solution

3 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)

nagendrathecoder · Answer 1 · 2012-05-11T02:15:00

Solution 1

Try this

select * from t1 UNION ALL select * from t2

Posted 11-May-12 2:15am

nagendrathecoder

Updated 11-May-12 3:17am

v3

Comments

Maciej Los 11-May-12 8:38am

Good answer, my 5!

nagendrathecoder 11-May-12 9:05am

Thanks

Maciej Los · Answer 2 · 2012-05-11T02:38:00

Solution 2

The prefer solution is:

SQL

SELECT *
FROM t1
UNION ALL
SELECT *
FROM t2

Read more:
Writing queries - basics[^]
SELECT[^]
SELECT Examples[^]
UNION[^]
ORDER BY[^]

Posted 11-May-12 2:38am

Maciej Los

Updated 11-May-12 4:00am

v2

Comments

nagendrathecoder 11-May-12 9:17am

select * from t1,t2 will do a cross join which i guess is not the result OP is expected.
Second query is correct one.

Maciej Los 11-May-12 10:00am

You are right! Thank you ;)

Wendelius · Answer 3 · 2012-05-11T10:05:00

Based on the information you have given about the tables, I'd suggest a redesign of the table structure.

Do you really need to separate the rows to two different tables? Could yo uuse one table instead? If the rows are somehow different, for example rows in the first table are valid while in the other table they are invalid, could you use an extra column to define the state of the row (just an example).