How to search the related information from other table and fill it .

Question

0.00/5 (No votes)

See more:

I have one table EMP where all information of employee are there.
EMP columns are:

EMPID
Lname
Fname
Department
Designation

And i have one more table called info.
Info columns are:
Empid
fname
departrment

EMP.EMPID=Info.EMPID

In info table EMPID are coming randomly from other table.Now in Info table only EMPID is there,so i want to fill other column of info table from EMP table whose EMPID is present on Info table...

Posted 4-Aug-13 20:00pm

Nawab Ahmad

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)

Status BreakPoint · Answer 1 · 2013-08-04T20:18:00

Solution 2

Your question is not clear for me.
If you want to update info table by EMP table's data, you can use "update ~ from" query.

In Normalize viewpoint, you should not store same data in different table.

Posted 4-Aug-13 20:18pm

Status BreakPoint

Comments

Maciej Los 5-Aug-13 2:24am

Agree! +5
The correct structure of database should looks like:
EMP (EmpID, Fname, Lname, DepId)
DEP (DepID, Dname)

ArunRajendra · Answer 2 · 2013-08-04T20:18:00

Solution 1

Try this code.

SQL

update  i
 set fname=e.Fname,departrment=e.Department
 from emp e , Info i
 where e.Empid= i.Empid

Posted 4-Aug-13 20:18pm

ArunRajendra

Comments

Nawab Ahmad 5-Aug-13 3:35am

Hi,
In my emp table i have like this
EmpId fname department
----- ----------- ---------
253 nawab software
123 ahmad programmer
147 xyz production

And in my info Table:
EmpId Fname department
----- ----------- ---------
253
123

so i want to fill the information in info table related to emp table,information of those guys whose id is present in the info table.

ArunRajendra 5-Aug-13 4:12am

Yes the given query will update the fields in Info table?

Nawab Ahmad 5-Aug-13 4:36am

But when i m executing this query it is showing error .......
plz help..

ArunRajendra 5-Aug-13 5:39am

what is the error?

Nawab Ahmad 5-Aug-13 23:38pm

Msg 207, Level 16, State 1, Line 5
Invalid column name 'Empid'.

ArunRajendra 6-Aug-13 0:22am

There are two possiblitites.

1. You dont have column called Empid in the table. Replace with a proper field name.
2. Its case sensitive. Replace the field name with proper case.