Cheers! The reason I ask is because when I run a query against the job table, and I inner join the locations and locations lookup table I get the same job listed many times, presumably because it is listed many times in the locations lookup table.
Any ideas on how I can stop it being listed multiple times? Thanks Sam ----- Original Message ----- From: "Daniel Field" <[EMAIL PROTECTED]> To: "ActiveServerPages" <[EMAIL PROTECTED]> Sent: Tuesday, October 01, 2002 9:48 AM Subject: RE: quick database design question > Yep, looks ok to me! > > -----Original Message----- > From: Sam Thompson [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, October 01, 2002 09:45 > To: ActiveServerPages > Subject: quick database design question > > > I just wanna double check that im doing the right thing! > > Ive got a database which contains job vacancies, and each job can be in > multiple locations around the world. > > So I need 3 tables right? > > 1 containing the job ID, job title etc, another containing the list of > locations and a location ID, and the last one which contains the job ID and > the location ID (lookup table). > > Is that the correct way of doing it? > > Thanks! > > Sam Thompson > > > --- > You are currently subscribed to activeserverpages as: [EMAIL PROTECTED] > To unsubscribe send a blank email to > %%email.unsub%% > > _____________________________________________________________________ > This e-mail has been scanned for viruses by the WorldCom Internet Managed > Scanning Service - powered by MessageLabs. For further information visit > http://www.worldcom.com > > > > _____________________________________________________________________ > This e-mail has been scanned for viruses by the WorldCom Internet Managed Scanning Service - powered by MessageLabs. For further information visit http://www.worldcom.com > > --- > 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]
