I am having 4 tables to join in the SQL Server and I also need to show Specific Columns in Data Grid View.
First Table : emp_details
Second Table : tbl_designation
Third Table: tbl_empcontribution
Fourth table: tbl_empdeduction
Columns that need to be shown in Data Grid View is
1.From the first table, I need to show emp_id, emp_name , emp_pf
2.From the second table, I need to show designation_name
3.From the third table, I need to show pfacc1 and pfacc2
4.From the Fourth table, I need to show pf_percent and pf_max
Can anyone help with this?