Multiple tables question in MYSQL

[Anon]

Ok I want to have it where I insert information into mysql into different tables so I can join the tables when i do a query. In order to do that I need one field in each table to be the same and a primary key right?

If not please let me know. If so, then all I have to do is do multiple sql insert commands to enter data into different tables then correct? then just run a join command referencing the primary keys correct?

Let me know if I am to confusing. I think I just confused myself!

[tomhath]

You need something to match up the rows between the two tables. Can be one column or several together. Primary keys serve another purpose, you don't need them for joins.

[Anon]

I think I got it. I used this sql statement and it seemed to work

$sql="SELECT table1.,table2. FROM table1 INNER JOIN table2 ON table1.id=table2.id WHERE table1.id='3'";

I then did a while statement and echoed out fields and they came up with the values where the id equaled 3. Is this the proper way?