I have two tables "client" and "proposal" in database, 

**db.client = > id,name  

db.proposal => clientID,proposalID** 

`select * from proposal` will select all the clientID and proposalID  

I want query, so that it print all proposal.proposalID with client.name instead of clientID