Need sql query for two tables join and two different column

This is my expecting result...

hi

What is your expected result can display in pic?

That you show in the pic that is coming from my query .

Sorry... My expecting result as below

Thanks

hi

whether you need two columns or something else

select t2.S_NAME,t2.R_Name from table1 t1 inner join table2 t2 on t1.F_ID1 = t2.C_ID1

Thanks and regards

Hi,

Find below image in details and no common fields in both table.

hi

I am not getting your point . Whether there are two tables or one table.

If two tables wat are the common column for joining?

Can describe briefly ?

Thanks and regards