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.
A common rock-forming mineral found in felsic igneous rocks, pegmatites and metamorphic rocks, muscovite is the lightest-colored member of the mica mineral group. Micas are a group of sheet silicate minerals distinguished by their perfect single cleavage.his cleavage allows mica minerals to be easily split into thin parallel sheets. In India and Eastern Europe, muscovite can be found in crystals large-enough to be split into sheets to be used as windowpanes.