Hi All,
I wish to build a query that will return a resultset compiling records from the 2 tables.


Employee Table
Id Name
1 ABC
2 DEF

Earnings Table

Id EarningsId Amount
1 1000 100
1 2367 500
2 586 1000
2 875 502
2 54 600

Output must be
Id Name
1 ABC 100 500
2 DEF 1000 502 600

The problem is theres no specific description for the EarningsId. A person can have any number of earnings. Theres no defined set of earnings id. It may or may not vary from person to person. Can anyone help in building the query to get my desired output



Thanks and Regards,
Anju Renjith