Linking tables in mySQL

[big man]

This might seem like a simple question, but i'm new to this.............

how do you link tables in mySQL. I have a name_id set as a primary key in one table, and then i have a name_id field in each of my other tables. How do i create the relationship between these??

Thanks for any help guys

Big man

[molacka]

You have already created the relationship by having the primary key of one table as the foreign key in another. You've now got to reference the fields you want in the query and where they match:

SELECT tbl_Main.name_first, tbl_Main.name_second, tbl_Account.account_no, tbl_Account.blah...
FROM tbl_Main, tbl_Account
WHERE tbl_Main.name_id = tbl_Account.name_id

that's about it really, unless you want to get into INNER, OUTER or NATURAL joins which take a bit more explaining

[big man]

I see - thanks for the help. I think i can get my head round this now

[cockneywanka]

you need to do an SQL join

something like

SELECT * from Customer c, Order o
WHERE c.customer_id=o.customer_id

this would get all columns from Customer, Order tables
where the customer_id key fields match in both tables

best get a book on SQL as the above example is a fairly simple
example

hth

cw

[funy]

If your talking books you should get

MySQL by Paul Dubois - ISBN: 0-7357-0921-1

I believe amazon should have it.

I learned everything i needed to know from there.


There may be books that go deeper but this is a great book for starters and for reference.

[mladen]

I agree, you could do worse than to get a book

I have 3 on sql and php

[big man]

Treated myself to a couple of those beginner - Teach youself books.

Very useful. I think i'm getting there now

Cheers guys