join or linking issue

[gauthamchilled]

i have two tables, on 1 table i have clientid,jobid, and title and other table i have clientid,emplid,and workhrs

when i join or link the table, i am not getting different job levels for emplid.

toget different job levels for different emplid..what to be done...pls help

attached an example please help.

[sumeet-vaidya]

Hi Gautham,

Kindly provide sample output as how you want your result to look.

Regards

Sumeet

[sujeetsingh]

I think it is working fine . Here is the sample with the second employee.

Please come in more words if you are looking for something else.

[gauthamchilled]

can you point me in screenshot where the emplid have different job title...i didnt see different job tilte for different employee.

[sujeetsingh]

can you please explain the exact data you need.?