hello!
not sure if this is possible but i need to construct a sql querie that
joins to another table. deal is this;
movies table: this has 30 movies in with a tape code:
ID TAPECODE MOVIE
1 A A Beautiful Mind
2 B American Pie 2
etc
a programming table that has 10 'movies' in shown by channel name:
CHANNEL MOVIE
Screen One 1
Screen Two 2
etc
i have created a relationship in access using the lookup wizard that
creates the link between the TAPECODE in the movies table and the MOVIE
in the programming.
when i create a querie that looks at the first movie it works, eg:
SELECT programming. channel, programming.movie, movies.movie
FROM programming INNER JOIN movies ON movies.id = programming.movie;
which joins it up so i get: 'Screen one A Beautiful Mind' rather than
'Screen one A'.
but when i try and add the next channels, they dont link up! i just get
the tapecodes.....
do i have to create a separate sql querie per channel?? this seems quite
hefty....
any ideas oh gurus?
cheers,
jake
---
You are currently subscribed to activeserverpages as: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
