insert value using 2 tables to update a column as main status using sql server

Question

0.00/5 (No votes)

See more:

Hi everyone .. can you help me how to create a source having this logic wherein i need to compare a certain value in the first table in which the second data will insert the assigned string value on its column and can be change within the late status

1st table

id   |   name    |  status |  age  |
1    |   danny   |  single |  20   |
2    |  marlon   | married |  38   |
3    |   paul    |  single |  25   |

2nd table

id   |  name      |  educational level   |  status  |  
1    |  danny     |   undergraduate      |  single  |
2    | marlon     |  college graduate    |  married |
3    | paul       |    college graduate  |  married |

in which the final output will be

id  | name   | status |
1   | danny  | single |
2   | marlon | married|
3   | paul   | married|

i hope you understand this scenario.. thanks for advance for you help..

Posted 11-Jul-13 2:02am

Member 10033107

Updated 11-Jul-13 2:03am

Maciej Los

v2

Add a Solution

Comments

Sriram Bala 11-Jul-13 8:06am

Hi, I am unable to understand your question. Are you looking for a SQL query to display the shown output?

Member 10033107 11-Jul-13 8:13am

yes i will program in sql server as my database wherein i will use it to get the values and compare it??

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)

Maciej Los · Answer 1 · 2013-07-11T02:05:00

Solution 1

Try this:

SQL

SELECT t1.id, t1.[name], t2.status
FROM FirstTable AS t1 INNER JOIN SecondTable AS t2 ON t1.id = t2.id

Posted 11-Jul-13 2:05am

Maciej Los

Comments

Member 10033107 11-Jul-13 8:26am

what if i use different columns name but same values?? there will be effect using this code?? btw thanks for you response :))

Maciej Los 11-Jul-13 8:28am

I don't get you ;(
Please, be more specific and provide more details... example data.

You're welcome ;)

Member 10033107 11-Jul-13 8:33am

for example i named 'status' as

in table 1 I use sta_tus and in table 2 is status..

there will be an effect using different column identifier? yet it has same value..? did you get me ?