SELF JOIN: is used to join a table to itself as if the table were two tables, temporarily renaming at least one table in the SQL statement. CARTESIAN JOIN: returns the Cartesian product of the sets of records from the two or more joined tables.Previous Page. JOIN is a means for combining fields from two tables by using values common to each. Consider the following two tables, (a) CUSTOMERS table is as follows: (b) Another table is ORDERS as follows: Now, let us join these two tables in our SELECT statement as follows:
Muscovite is the most common mica, found in granites, pegmatites, gneisses, and schists, and as a contact metamorphic rock or as a secondary mineral resulting from the alteration of topaz, feldspar, kyanite, etc.
From Wikipedia, the free encyclopedia. For other uses, see Muscovite (disambiguation) . Muscovite (also known as common mica, isinglass, or potash mica) is a phyllosilicate mineral of aluminium and potassium with formula K Al 2 (Al Si 3 O 10)(F ,O H) 2, or (KF) 2 (Al2O3) 3 (SiO2) 6 (H2O).It has a highly perfect basal cleavage yielding remarkably thin laminae (laminÃ¦) sheets which are often highly. elasticuscovite has a Mohs hardness of 2â2.25 parallel to the [001] face, 4 perpendicular to the [001] and a specific gravity of 2.76â3. It can be colorless or tinted through grays, browns, greens, yellows, or (rarely) violet or red, and can be transparent or translucent.