User810354248 posted
Hi Good Evening
In my asp.net+VB+SQL web i have following two table (Main and emp_rmk) tables.
Main
MID EmpNo Name DOB Gender Status Remarks
1 123 Baiju 10/07/70 Male Active Frequent absent
2 124 Raju 2 0/07/1980 Male Active Absconding
3 126 Sanath 08/06/2012 Male Active Good Performer
Emp_Rmk
RmkID empno Track_Records
1 124 Poor Performer
2 123 Leave extended wef 01 jan 20
3 123 Previous project incomplete
I want data in grid view like this
MID EmpNo Name DOB Gender Status Remarks
Track_record
1 123 Baiju 10/07/70 Male Active Frequent absent
Previous project incomplete, Leave extended wef 01 jan 20
2 124 Raju 2 0/07/1980 Male Active Absconding
Poor Performer
3 126 Sanath 08/06/2012 Male Active Good Performer
I tried like this
SELECT * FROM [Main] left join emp_rmk ON main.empno = emp_rmk.empno
but if there is any track record then multiple rows are being created for a single employee