asp.net mvc 4 - how to display data in a single view from multiple tables in mvc 5 -
emp_table
sno name salary country 1 xxxx xxxx 101 2 xxxx xxxx 102
country table
cid countryname 101 ind 102 usa
output
sno name salary country 1 xxxx xxxx ind 2 xxxx xxxx usa
select e.sno, e.name, e.salary, c.country emp_table e,country c e.country = c.cid
Comments
Post a Comment