Joins of SQL tables

Results 1 to 3 of 3

Thread: Joins of SQL tables

  1. #1
    Kaarthik Guest

    Default Joins of SQL tables

    I am creating many tables of the same kind to enable clients to upload data into thier own table..but the problem is if I wish to make a search for data from these tables then I have to join all of them ( which can be 100s of tables ). Is there a way I can create aa table which continously updates data from all these tables..??? can I use the master table in the SQL server?

  2. #2
    Milt Guest

    Default RE: Joins of SQL tables

    Couldn&#039t you use a trigger, or a series of triggers that update the MIS table everytime a record is created in the child tables?

  3. #3
    Milt Guest

    Default RE: Joins of SQL tables

    Thanks, I will give it a shot.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts