Joining Keys

[ndog4ever]

I am trying to design a database with multiple tables. I want to have a primary key in one of my tables point to the primary key of another.
Example routers.serial3_dlci21.system, something along those lines, where system is the database, and routers is the general table with general info, and serial3 contains all the specific customer info for that interface. Any help would be greatly appreciated because I am very new to MySql.

Thanks

 

[KarveR]

select r.field1,r.field2,s.field3,s.field4 from routers r,serial s WHERE r.name = s.name;

This links the tables by the common field "name" the join is achieved by aliasing the tables r and s and prepending th efield names i.e. r.name = the field "name" table routers.

i think thats clearish ;-) ***************************************
Party on, dudes!