Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by ontim

  1. ontim

    Selecting from multiple tables and displaying in new table

    Hi there, Thanks Golfboy,I have tried using your tip and it works fine only till 2 tables but when I try to join 7 tables as shown in the schema in my previous mail ,it does not give me exact result.Since I feel using LEFT OUTER JOIN is more relevant it reduces the records when I join all...
  2. ontim

    Selecting from multiple tables and displaying in new table

    Hi there, Thanks Golfboy, for the solution you have given to me.I think this should work properly for my schema.Since I am trying it fully now, I have not finished yet.So if I have some problem or if there is still some problem then I surely will ask you. Meanwhile let me try the solution...
  3. ontim

    Selecting from multiple tables and displaying in new table

    Hi there, Aalmeida thanks for this one.We are a little close.I have tried as you said,but in doing so it gives me a error which says :- "All queries in an SQL statement containing a UNION operator must have an equal number of expressions in their target lists." But when I changed the...
  4. ontim

    Selecting from multiple tables and displaying in new table

    Hi there, Stoyanbd, I tried using 'Joins' as you have mentioned but in doing so it gives duplicate records in all the columns with the original records because the number of records in all the tables are not the same.In students it is 1500.In degree the records are 1200 since 300 students...
  5. ontim

    Selecting from multiple tables and displaying in new table

    Hi there, Sorry for delay in replying.Thanks stoyanbd and aalmeida I really appreciate your quick response and help.But I still need more details for query retrieving. Aalmeida,I would definately try using Union but that doesn't solve my first part i.e selecting from multiple tables...
  6. ontim

    Selecting from multiple tables and displaying in new table

    Hi there, Stoyanbd thanks for your advice,this would help me to eliminate null records,but I still have no idea about the first part as to how can I display all the records from 5 tables into one single table avoiding duplicates.For detailed description see my message in the post...
  7. ontim

    Selecting from multiple tables and displaying in new table

    Hi there, I am doing a project for "Students Management System" using SQL server 7. I have all the rquired 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...
See more

Part and Inventory Search

Back
Top