I would do it like this: Job table With JobID
INDUSTRIES table With IndustryID And table (Table Name) With JobID And IndustryID Then you can create a view with the three tables This way a job can belong to many Industries and viceversa. Gustavo ----- Original Message ----- From: "carina cojeen" <[EMAIL PROTECTED]> To: "CFTALK" <[EMAIL PROTECTED]> Sent: Monday, February 04, 2002 7:34 PM Subject: [CFTALKTor] stumped on SQL > Hi all, > > Hoping someone can help me out here with a more complex SQL query... > > I'm sure it's not that hard but I'm just stumped... > > I have normalized the database for the following in order to save room > in the JOBs table: > > JOBS table > - contains 3 columns with the primary ID of an industry: > Industry - IndustryID from INDUSTRIES table > Industry2 - another IndustryID from INDUSTRIES table > Industry3 - yet another IndustryID from INDUSTRIES table > > INDUSTRIES > IndustryID - primary key - integer > IndustryName - text value > > Now, of course, when I pull a query, I want to set up the query to show > the IndustryName which is text, instead of the integer. > > When there was only one Industry column in the Jobs table, that was > fine, I could do a simple table join... but now that I have 3 separate > Industry columns, how do I set up the query to have the extra text > IndustryName values? > > help help help??? > > thanks! > carina > > -- > Carina R. Cojeen > x a r d e s i g n s > web programming and design > www.xardesign.com > c. 416.434.8823 > h. 416.778.6024 > > > - > You are subscribed to the CFUGToronto CFTALK ListSRV. > This message has been posted by: carina cojeen <[EMAIL PROTECTED]> > To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/ > Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/ > This System has been donated by Infopreneur, Inc. > (http://www.infopreneur.net) > - You are subscribed to the CFUGToronto CFTALK ListSRV. This message has been posted by: "Gustavo Jabbaz" <[EMAIL PROTECTED]> To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/ Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/ This System has been donated by Infopreneur, Inc. (http://www.infopreneur.net)
