linking mysql tables

[Guus]

I recently started using mysql, and I'm trying out some stuff to learn a bit more. I decided to implement a small music charts system: it will hold the data telling you which song is on which position in a certain week. For now, I use two tables:

[outlaw41]
week
position1
position2
position3
(..all the way to...)
position40
position41

[song]
index
title
artist
album

The second table (song) holds information on the songs themselves. Index is a unique integer.
The first table (outlaw41) holds the information on the charts. Each week, a new row is added, reflecting the charts of that week (which song was on number one, which one was number 2, etc).

My question is: how do I link these tables? Somehow, I want to tell the [outlaw41] table that week3's position1 is the song with index x in the [song] table.

[Moose69]

The best way would be to structure the table so that your Outlaw41 table contains the unique index values from the Song table rather than the song titles.

[qwerty_smith]

having neber used mysql, this is all i can suggest...

http://www.mysql.com/doc/M/E/MERGE.html

[edit]but yes, moose is right. make sure you have identical keys in both tables and (i'm thinking of M$ access right now) there should be an option to link one to another. i'll have to dl mysql. i've been making the slow move away from M$ anyhow.[/edit]