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

Popular posts from this blog

java - UnknownEntityTypeException: Unable to locate persister (Hibernate 5.0) -

python - ValueError: empty vocabulary; perhaps the documents only contain stop words -

ubuntu - collect2: fatal error: ld terminated with signal 9 [Killed] -