How to get data two tables in SQL Serever

Question

1.00/5 (1 vote)

See more:

I have two tables containing same fields in database.
One table will contain data..
2nd table will contain data which are changed in table 1..SRNO is same in table 1 and table 2
Now I want a report based on date.
How to check for the date selected in both tables and get report for the selected date?

Posted 1-Jul-13 3:30am

Rachna0309

Add a Solution

Comments

Prasad Khandekar 1-Jul-13 9:39am

Hello Rachna,

You can use INNER JOIN Query to fetch data from both the tables. Based on your inputs the JOIN will be on the SRNO column. The query in your case might look like the one shown below.

SELECT t1.*
FROM table1 AS t1
INNER JOIN table2 AS t2
ON t2.srno = t1.srno
WHERE t1.data = YYYYMMDD.

Please have a look at following MSDN Link to know more about date literals. (http://msdn.microsoft.com/en-us/library/ms187819.aspx)

Regards,

ZurdoDev 1-Jul-13 9:58am

Where are you stuck?

Maciej Los 1-Jul-13 11:36am

We need example data and expected output. Use "Improve question" widget.

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)

OmprakashDubey · Answer 1 · 2013-07-01T09:27:00

Solution 1

Suppose You have two table i.e. table1 and table2 the query will be as below

SQL

SELECT t1.srNo,t1.Data as OLDData,t2.Data as ChangeData  
FROM table1 AS t1
   INNER JOIN table2 AS t2
     ON t2.srno = t1.srno
WHERE t1.date = YYYYMMDD or t2.date=YYYYMMDD.

Posted 1-Jul-13 9:27am

OmprakashDubey

OmprakashDubey · Answer 2 · 2013-07-01T09:28:00

Solution 2

Suppose You have two table i.e. table1 and table2 the query will be as below

SELECT t1.srNo,t1.Data as OLDData,t2.Data as ChangeData
FROM table1 AS t1
INNER JOIN table2 AS t2
ON t2.srno = t1.srno
WHERE t1.date = YYYYMMDD or t2.date=YYYYMMDD.

Posted 1-Jul-13 9:28am

OmprakashDubey

Comments

Maciej Los 1-Jul-13 15:43pm

Do not repost the same answer! Please, remove it to avoid down-voting.