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)
