topic Re: Getting table field in other table in App Development

Getting table field in other table

Bharathi09 — Fri, 06 Jan 2023 03:58:36 GMT

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

Re: Getting table field in other table

sidhiq91 — Fri, 06 Jan 2023 06:26:45 GMT

@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.

Re: Getting table field in other table

Bharathi09 — Fri, 06 Jan 2023 06:32:31 GMT

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