read insert update delete form multiple tables in a singleDB

Question

Dear friends, I have a single database in SQL Server 2010, with 3 tables, first table contains a members personal info, Second table conations 10 years overview of the amount paid by the and the third table for another 10 years overview.


At the moment I can search and display and update and delete from table one.

What I want to do is that when I search or display or update or delete I can use the info from the Second  & Third table also, so I have the overview information from all the tables shown up in my from.


Question is how to or in what way I write an SQL statement which gets or sets data from all three tables in a single click of button, and how to write a single or multiple statements, hope this question is clear enough.


Kind regards 
JG