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

use this query to solve your problem


select t1.Firstname,t2.FirstName from  table1 t1 join table2 t2 on t1.id=t2.Rnumber

this query is gives you require output