Which join to use ? and how to add rank column on the result I have two tables 

Table4 - Columns (ID, NAME, Money)
Table5 - COlumns(ID, PLACE)

Note: Table 4 has more IDs than table5 

I am trying to use a join such that I get the following table

Table6 - Columns(Rank,ID,Place,Name,Money)

Also I want it to be such that when I get this result the ID values that are contained in Table4 whether or not they are contained in Table5 tp retain their ID and Name and Money Values.

In addition I would also like to have a rank column in the new table as the first column where the rank shown is 1 if your Money is the highest in the ID, and 2 if it is second highest etc. 

So far I tried using the following join 

Select * 
From Table4 
  left outer join Table5  on Table4.ID = Table5.ID


but the problem here is that the LID values unique to table4 drop their corresponding values for name and money. 

Also how can I use the rank function here to get the desired result I tried using this but to no avail

select * 
from (
   SELECT  RANK() OVER (PARTITION BY ID ORDER BY Money DESC) as RN,ID,Place,Name,Money
   FROM Table4
)
With out some sample code to go on I created my own set 

I had to join on both ID and Name for the rank in order to prevent cross joins

create table #Table4 (ID int, Names nvarchar(25), Moneys Money)
create table #Table5 (ID int, Place nvarchar(25))

insert into #Table4(ID,Names,Moneys)values(1,'waffles',1000), 
   (2,'Pancakes',2000),(3,'Blueberries',3000),(3,'Eggs',4000),(3,'Toast',5000)
insert into #table5(ID,Place)values(1,'House'),(2,'Kitchen')

select x.Rn, t4.ID,t5.Place,t4.Names,t4.Moneys
from #Table4 t4
left join #table5 t5
    on t4.ID = t5.ID
inner join (select t4a.ID, t4a.Names, rank() over(partition by t4a.ID order 
     by t4a.Moneys desc) as Rn from #Table4 t4a) x
    on t4.ID = x.ID 
    and t4.Names = x.Names
order by ID,RN


Results will look something like this 

Rn  ID  Place   Names       Moneys 
1   1   House   waffles     1000.00
1   2   Kitchen Pancakes    2000.00
1   3   NULL    Toast       5000.00
2   3   NULL    Eggs        4000.00
3   3   NULL    Blueberries 3000.00