I'd like to have a query (SQL Server 2012) do the following: Update data from one table to another where there is no common linkable record (pretty sure I can't just join and then update). only similarity is that the tables are of the same structure. to keep it simple (transferring 100+ items). so,
An inorganic compound is a compound that is not organic. The term is not well defined, but in its simplest definition refers to compounds that do not contain carbon, and not consisting of or deriving from living matter. Inorganic compounds are traditionally viewed as being synthesized by the agency of geological systems.
References. 1  An organic compound is any of a large class of chemical compounds whose molecules contain carbon. For historical reasons, a few types of compounds such as carbonates, simple oxides of carbon and cyanides, as well as the allotropes of carbon, are considered inorganic.