junction tables

  • Thread starter Thread starter Marie
  • Start date Start date
M

Marie

can I join existing tables (with data already entered) with junction tables
(and How)
Thanks
 
Junction tables form the "to" section of a many to many relationship.

You would need to give more details of what you are trying to do to get a
workable answer
 
Marie said:
can I join existing tables (with data already entered) with junction tables
(and How)
Thanks
Click to expand...

If, say, you had a table of employees, and table of company vehicles,
you could create what's called an "associative entity" table which
contained (apart from its own primary key) the primary keys of the other
two tables, plus, perhaps, the date the vehicle was adopted by the
driver, and perhaps the insurance policy number.

Phil, London.
 
Back
Top