What is the different JOIN statement?
We have 4 different JOIN statements. INNER JOIN LEFT JOIN RIGHT JOIN FULL JOIN Consider 2 tables, First scenario- we need all the data that are common for table 1 and table 2. Then we go for INNER JOIN Second Scenario - We need all the data from table 1 and only matching data from table 2 - then we go for LEFT JOIN Third scenario- we need all the data from table 2 and and only matching data from table 1. Then we go for RIGHT JOIN Fourth Scenario - We need all the data from table 1 and table 2 - then we go for FULL JOIN
How to achieve an individuals Short term and Long term financial Goals
An individual can have many short term and long term goals in life. First step is to list all the goals that you have in mind. 1. List of short term and Long term goals 2. Amount required to achieve each of these goals 3. Tenure/time period with in which you want to achieve these goals 4. Now from the available financial products, we can plan how much money we have to invest in each of these products so that on the due date, we will have the required capital capital to satisfy our goals. 5. Note: We should start investing for all the goals at a time at least in small amounts.
What are the type of finance that are available for a company?
There are 2 major types 1. Debt 2. Equity The company first go for debt i.e getting loan from a bank because of the cost of capital involved in it. The cost of capital in Debt is very less than the cost of equity. Equity is nothing but going to the public to raise money via IPO process and the cost of capital is high.