read insert update delete form multiple tables in a singleDB
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