Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
memory721
Starting Member
8 Posts |
 Posted - 2010-06-13 : 10:04:55
|
| Hello,I have a query that is as follows:Select category_name ,rule_name , rule_builders_id , rule_builders_name from rule_categories inner join rules on rule_categories.id=rules.rule_category_id inner join rule_builders on rule_builders.id = rules.rule_builder_id WHERE category_name = 'Archive' The problem is that in the rules table where I have the column name rules_name, that column only houses the internal definition of the rule. To get the user friendly description of the rule_name column, I have to somehow use the flex_labels table and use the column named 'value'. The same goes for the rule_builders_name column from the rule_builders table. I have to use the flex_labels table column 'value' to get the correct description. I just have no idea how to map the rules.rules_name to flex_labels.value and the rule_builders_name to flex_labels.value.Can somebody please help me?Thank you.SQL user |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
|
|
|
|
|
Subqueries??