Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Posts
    14

    Question The intermediate table joining 2 tables

    Hi to all ....

    i am working on a project that involves employees and projects...
    One employee can work on different projects....and one project can have more that one employees( may me 5, 10 or 15)
    I have created a table "Employee" , "Project" and "EmpProject" to link the two tables. EmpProject contains EmpID from Employee and ProjID form Project.

    The problem here is ... How to insert values in the EmpProject table...
    when ever an employee joins a project or a new project is started.

    regards....

    i will be waithing for a quick prompt.

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171

    Re: The intermediate table joining 2 tables

    What do you mean? To insert values into EmpProject you would obviously use an INSERT statement like:

    insert into EmpProject (EmpID, ProjID) values (21, 42);

    Where is the difficulty?

Posting Permissions

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