Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-09-06 : 09:18:50
|
| Tim writes "Hi there, I am doing a project for "Students Management System" using SQL server 7. I have all the required data of the students within 5 different tables but in a single database. I am trying to display all the data from 5 different tables into 1 single or in a new table. Now my problem is that I am not able to figure it out, how to do that. There is one column called 'Rollno' common in all the tables. So I have also tried to do with alias joins, but in doing so it reduces the amount of results and also gives duplicate records. Since there are around 1500 records and a lot of rows have null value, how could I eliminate those blank records.So please help me out, how can I display the combined data into a new single table. Also I would like to know how to export the query results into text files or convert it into HTML pages. Is there any free tool available for that online.Detailed explanation would be helpful and appreciated.Many thanks in advance." |
|
|
|
|
|
Selecting from multiple tables and displaying it into new single table??