When the two security filters from the same table are combined in the query, the filter conditions are combined using the OR operator, this is appropriate for most security filters defined on dimension tables, for example: If a user is given Role A and Role B, then the user can view data for both the Coke and Pepsi products. Role B is assigned the filter, Product = 'Pepsi' Role A is assigned the filter, Product = 'Coke' For example, consider the following filters: Using the OR operator works in most cases because a user can view a union of all the rows selected by the security filters. Comments, questions and errors shouldbe sent to pages are provided to the IOCD to assist in capacity building in chemical education.When there are no functional groups defined, all the security filters applied to a given table, regardless of the associated role, and are combined using the OR operator. This page is the property of William Reusch. Several methods of naming lactones have been used. Peroxides, followed by disulfides & diselenides Ethers followed by sulfides & selenidesДЎ. Hydroperoxides, followed by thiohydroperoxides & selenohydroperoxidesДЎ6. Alcohols and Phenols, followed by thiols & selenolsДЎ2. Ketones, followed by thioketones & selenoketonesДЎ1. Aldehydes, followed by thioaldehydes & selenoaldehydesДЎ0. Acids (in the order COOH, C(O)O 2H then their S and Se derivatives, followed by sulfonic, sulfinic, selenonic, etc., phosphonic, arsonic, etc., acids)Д©. Decreasing Priority Order of Principle Characteristic Groups Identified by a Suffix 1. All other groups are then cited as prefixes. When a compound contains more than one kind of group in this list, the principal characteristic group is the one nearest the top. The following table gives the priority order of suffix carrying groups in arriving at a IUPAC name. Note that only one functional group suffix, other than 'ene' and 'yne', may be used in a given name. Group Names and Suffixes for Some Common Functional Groups Specific examples of their nomenclature will be provided as the chemistry of each group is discussed. A summary of some of these groups and the characteristic nomenclature terms for each is presented in the following table. There are, however, many other functional groups that are covered by the IUPAC nomenclature system. An introduction to functional group nomenclature was limited to carbon-carbon double and triple bonds, as well as simple halogen groups. The previous discussion has focused on the carbon framework that characterizes organic compounds, and has provided a set of nomenclature rules that, with some modification, apply to all such compounds.

Comments, questions and errors shouldbe sent to pages are provided to the IOCD to assist in capacity building in chemical education. This system, known as the Cahn-Ingold-Prelog rules, uses and elaborates the priority rules developed earlier. The relationship of the sequence-rule-preferred substituent at geminally substituted positions, relative to the reference group, is cited as c- or t-, as appropriate.ДЄn alternative system which specifies the absolute configuration of substituted carbon atoms may also be used.

If none of the substituents is named as a suffix, then that substituent of the pair of substituents having the lowest number, and which is preferred by the sequence rule, is chosen as the reference group. When two different substituents are attached at the same position of a monocycle, then the lowest-numbered substituent named as a suffix is selected as reference group. The relative configuration of other substituents are then reported as cis ( c) or trans ( t) to the reference substituent. When one substituent and one hydrogen atom are attached at each of more than two positions of a monocycle, the steric relations of the substituents may be expressed by first identifying a reference substituent (labeled r) followed by a hyphen and the substituent locator number and name. Nomenclature Examples Examples of the IUPAC Rules in Practice

Functional groups table