how do you make tables relate?

[adamduritz99]

i was wondering how do you make a table relate to another table in mySql?

[kailien]

A column from each relating table must contain the same data. For example:

Table A, column 1 = testID

Table B, column 1 = A_testID

Query:

select * from A, B where A.testID = B.A_testID;

You may want to read up on Normalization.

Cheers,

Kai