Displaying Data from Multiple Table HD

We keep record in different tables to make record keeping system simpler. Many database support relation model which means data that has been saved in one table is no necessary to save in another table but can be referenced to that table using the concept of primary-foreign key. Thus using this concept table can be sub-divided and finally can be joined which is called view to get desired output. For more information about views http://www.w3schools.com/sql/default.asp http://msdn.microsoft.com/en-us/library/hh272686(v=vs.103).aspx