write query to get all columns from two different tables

Question

Hi,

My two database tables are like this:

Table1:

Id      Firstname
1         Darma

Table 2:

Rnumber      Firstname
1                Teja

My final outcome should be: Darma Teja

I tried sql joins, But it works only when I have have same column names. In my tables, I dont have same column names.


Many thanks,

Darma

Answer 1

Have a look at the below links:

 

http://www.primaryobjects.com/2015/05/08/token-based-authentication-for-web-service-apis-in-c-mvc-net/ 

 

http://www.dotnetcurry.com/aspnet/1223/secure-aspnet-web-api-using-tokens-owin-angularjs