Design for table with multiple links to other table I am designing a database to keep track of our network equipment. My db has 2 tables:

sites &amp; circuits

(circuit = cable) &amp; (site = property location)

Each circuit runs between two sites, so it should relate to two sites, yes? The circuit table has the following  columns: ID_circuit (PK), circuit_number, site1, site2. I thought that I could relate my ID_site field to both site1 and site2, but I cannot. Would I be better off creating a whole other table to hold the locations of both cable ends?
Site1 and site2 can both be FKs, linked to the ID_site PK. This works on any rdbms that i'm aware of.

Example Query:

SELECT CT.site1, CT.site2, S1.site_description, S2.site_description
FROM circuit_table AS CT
INNER JOIN site_table as S1
  ON CT.site1 = S1.ID_site
INNER JOIN site_table as S2
  ON CT.site2 = S2.ID_site