how retrieve info from 2 tables based on composite primary key...!

See more:

SQL-Server-2005

SQL-Server

how retrieve info from 2 tables based on composite primary key...!
The firm has a few outlets that receive items for recycling. Each of the outlets receives funds to be paid to deliverers. Information on received funds is registered in a table:

Income_o(point, date, inc)

The primary key is (point, date), thus receiption of money (inc) takes place not more than once a day (date column does not include time component of the date). Information on payments to deliverers is registered in the table:

Outcome_o(point, date, out)

In this table the primary key (point, date) also ensures bookkeeping of the funds distribution at each point not more than once a day.



Question:


Under the assumption that the income (inc) and expenses (out) of the money at each outlet are written not more than once a day, get a result set with the fields: point, date, income, expense.
Use Income_o and Outcome_o tables.

Could any one explain how to find the solution ...!