Getting table field in other table

[Bharathi09]

Hi All,

I have 2 tables containing Employees details with fields ID,Name,Department  in one table

and ID,DOJ,DOL in another table

I also have 3rd table which contains Location of employee and other fileds too

I merged first two tables using concatenation

I want to populate 3rd table location in Merged table

Please help

[sidhiq91]

@Bharathi09  Could you please post what other fields do we have in another table?

May be joins would be a good option to do it.

[Bharathi09]

Actually in 1st tables fields are:
EMPname,ID,Department,Code,city

2nd table:
EMPNAME,ID,DOJ,DOL,Code,CITY

3rd table:
City,State, Location,Manager

Here I'm getting location field by joining city and state as

please help