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.
The heat and pressure of metamorphism transforms clay minerals into tiny grains of mica which enlarge as metamorphism progresses. Muscovite can occur as isolated grains in schist and gneiss or it can be abundant enough that the rocks are called mica schist or micaceous gneiss. Muscovite is not especially resistant to chemical weathering. It is quickly transformed into clay minerals.