select two columns from two tables

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

hi ,i have two tables.dept and employee,Below I have shown the structure .here Did is primary key of dept table and Foreign key of employee table.

dept
Did Dname Dnumber
1 d1 23
2 d2 34
3 d4 67

employee
Eid Ename Did
1 e1 1
2 e2 2
3 e3 2

here ,I have to select Ename with respect to Dname..please someone help me..

thank you in advance

Posted 12-May-12 0:31am

chinta123

Add a Solution

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)

Wendelius · Answer 1 · 2012-05-12T00:33:00

Solution 1

Sounds very much like homework... The thing you need is a join. I suggest going through this tutorial: SQL Joins[^]

Posted 12-May-12 0:33am

Wendelius

Comments

chinta123 12-May-12 7:09am

can u please write the query here?

Wendelius 12-May-12 7:23am

It's important that you try to do the homework yourself. The only way to learn is by trying. And when you try I'm certain that you find, it's not so hard after all :)

If you write the query and encounter a problem, you can post the query you have written with the description of the problem and I'm sure that you'll get help to solve the specific issue.

I'm sure that you if you go through the tutorial and try to write the query, you actually solve it in no time :)

Maciej Los 12-May-12 8:57am

Good answer! +5

Wendelius 12-May-12 12:39pm

Thanks

Maciej Los · Answer 2 · 2012-05-12T02:56:00

Solution 2

If Did is a PK in dept table and FK in employee table, INNER clause should looks like:

SQL

FROM dept LEFT JOIN employee ON dept.Did = employee.Did

It mean: fetch all data from dept table and metches records from employee table
The rest of query try to write yourself.

Posted 12-May-12 2:56am

Maciej Los

Updated 12-May-12 2:57am

v2

Comments

chinta123 13-May-12 0:57am

I also that much..can u pls tell me next??