Multiple inner joins are abit different in Access, the easiest way to do it is to create a query in design view, select each field and check the box which says "Show". Access will do the hard work for you. You can then save the query in Access, and call it from your asp page (select * from mySavedQuery).
HTH Sam Thompson ---------------------------------------------- 2cs Communications Ltd http://www.2cs.com [EMAIL PROTECTED] T: 01473 622263 F: 01473 622515 ----------------------------------------------- ----- Original Message ----- From: "jake williamson" <[EMAIL PROTECTED]> To: "ActiveServerPages" <[EMAIL PROTECTED]> Sent: Monday, August 19, 2002 11:43 AM Subject: muliple join tables > 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.unsub%% > --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
