Query help needed desperately

[Maracles]

I have 2 tables:

 

1 - title (the columns are: titleID, title)

2 - talent (the columns are: talentID, first_name, last_name)

 

Titles in the first table are film titles, and entries in the second tables are actors. There can therefore be multiple actors in one film. How do I show this?

 

I know I need a link table or some sort  so that if for example;

Indiana Jones = titleID of '1'

Harrison Ford = talentID of '1'

Steven Spielberg = talendID of '2'

 

The link table would show two columns:

 

col1 - titleID

col2 - talentID

 

The link table would then be:

 

titleID    talentID

 

1                1

1                2

 

I cannot figure out even after hours of trying how to select all talentID in the link table that have a titleID of 1. please help!

 

 

[fenway]

Why won't a simple join work?

[DaiLaughing]

A simple join would end up with a many-to-many relationship.  Each actor will be in many films but each film will have many actors.

 

You need an intervening table to record who was in what.  Film -> actedIn <- talent.

 

Can't think of a good name for the new table for some reason!

[fenway]

The OP wanted to query the table, not design it.