HI

I want to create a view to get records from multiple tables. I have a UserID in all the tables. When I pass UserID to view it should get records from multiple tables. I have a table UserInfo with as data as UserID=1, FName = John, LName=Abraham and Industry = 2. I have a Industry table with data as ID=1 and Name= Sports, ID =2 and Name= Film. When I query view where UserID=1 it should return record as FName =John, LName = Abraham and Industry= Film

How to write query?

Thanks in advance

Take a look at this link

http://www.w3schools.com/sql/sql_join_inner.asp

Try to write the query and report back if needed.