Hi,
I am trying to join 5 tables.
I want to create one big table CommDevices as primary key.
Here are table names: CommDevices, People, Facility, Organization, Event and CommDevices.
There are junction tables(middle tables), PeopleCommDevices, FacilityCommDevices, OrganziationCommDevices and
EventCommDevices.
Here are primary keys for each table.
CommDevices - CommDeviceID
People - PeopleID
Facility- FacilityID
Organization - OrganizationID
Event - EventID
PeopleCommDevices- PeopleID & CommDeviceID
FacilityCommDevices - FacilityID & CommDeviceID
OrganziationCommDevices -OrganizationID & CommDeviceID
EventCommDevices EventID & CommDeviceID
What I am trying to do is to create one big table with the CommDeviceID as primary key.
I am trying to find everything which is associated to that CommDeviceID primary key.
Thanks much.
I am trying to join 5 tables.
I want to create one big table CommDevices as primary key.
Here are table names: CommDevices, People, Facility, Organization, Event and CommDevices.
There are junction tables(middle tables), PeopleCommDevices, FacilityCommDevices, OrganziationCommDevices and
EventCommDevices.
Here are primary keys for each table.
CommDevices - CommDeviceID
People - PeopleID
Facility- FacilityID
Organization - OrganizationID
Event - EventID
PeopleCommDevices- PeopleID & CommDeviceID
FacilityCommDevices - FacilityID & CommDeviceID
OrganziationCommDevices -OrganizationID & CommDeviceID
EventCommDevices EventID & CommDeviceID
What I am trying to do is to create one big table with the CommDeviceID as primary key.
I am trying to find everything which is associated to that CommDeviceID primary key.
Thanks much.