What is the layout of the new table? There is always a way to combine tables. The trick is to combine them in a way that makes sense. If you just want a table of people regardless of whether the people are students or faculty then you could
SELECT * FROM table1
SELECT * FROM table2
If you want to include a field that distinguishes between faculty and students you could do
SELECT 'S' AS classID,* FROM table1
SELECT 'F' AS classID,* FROM table2
which will return the fields classID, lname, fname and age where classID=S indicates a student and classID=F indicates faculty. If you want to insert the records inito a new table then add
I Developed application in C# with crystal reports and created setup file in third party (Advance) Installer.When i installed my application on client system application is working but ...