Join 3 tables in ASP.NET Core MVC
I am trying to learn API development. This is my query: select companyusers.companyid, companies.companyname, companyusers.name, companyusers.id, compnayusers.designation, personalInfo.otherinfo from companyusers, companies, personalInfo where compnayusers.companyid = 2 and compnayusers.id = personalInfo.userID and compnayusers.companyid = companies.companyid and compnayusers.IsRemote = 0 order by compnayusers.name I have to create an API that would parse the results of the above … Read more